phpPgAdmin permission denied when viewing sequences

Symptoms

When using phpPgAdmin to view a sequence within a database, an error similar to the following is shown:

SQL error:

ERROR: permission denied for relation table_name_seq

Description 

This issue is caused by missing or incorrect grants for the cPanel user to the Postgres database sequences.

Workaround

To re-add the grants for the cPanel user to the database, perform the following via SSH:

Access the Postgres Shell:

psql -U postgres

Connect to the affected database

\c user_database

Add the grants for the cPanel user to the Database:

user_database=# GRANT USAGE, SELECT ON ALL SEQUENCES IN SCHEMA public TO user; 

Example output of the process is below:

# psql -U postgres
psql (9.2.24)
Type "help" for help.

postgres=# \c user_database
You are now connected to database "user_database" as user "postgres".
user_database=# GRANT USAGE, SELECT ON ALL SEQUENCES IN SCHEMA public TO user; 
GRANT
user_database-# \q