Grant a user's permissions to a PostgreSQL database
Once you have created a user to use a database you need to grant that user permission to use the database. If you have not yet created a user, refer to Creating a PostgreSQL user for more information.
To grant user permissions to a PostgreSQL database:
-
Click on the PostgreSQL databases button on the home page.
-
Choose the specific user from the User drop-down list and the specific database to grant permissions to from the Db drop-down list.
-
Click on the Add User to Db button. The user now has permission to use that database and sample connection strings are shown in the PostgreSQL window.
Removing a user's permissions
A user will no longer be able to access a particular database when you have removed their permissions to that database.
To remove a user's permissions:
-
Click on the PostgreSQL databases button on the home page.
-
Click on the Delete button next to the specific user underneath the name of the database in the Databases area.
Managing PostgreSQL databases
CPanel includes a web-based PostgreSQL management tool called phpPgAdmin. This tool allows you to manage all aspects of your database structure and data. Refer to the phpPgAdmin homepage if you need to know more about using phpPgAdmin.
To manage PostgreSQL databases using phpPgAdmin:
-
Click on the PostgreSQL databases button on the home page.
-
Click on the phpPgAdmin link at the base of the window. Refer to the phpPgAdmin homepage if you need to know more about using phpPgAdmin.