1. Portal Home
  2. Knowledgebase
  3. Unlimited Hosting
  4. cPanel X3
  5. PostgreSQL
  6. How can I Grant a user's permissions to a PostgreSQL database?

How can I 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. 1- Click on the PostgreSQL databases button on the Cpanel home page. 2- Choose the specific user from the User drop-down list and the specific database to grant permissions to from the Db drop-down list. 3- 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.

Related Articles

What is PostgreSQL?

PostgreSQL is, like MySQL, essentially an SQL server and database - it responds to requests for information that are written in SQL. You can communicate with PostgreSQL using a wide variety of...

How to add a PostgreSQL database?

1- Click on the PostgreSQL databases button on the Cpanel home page. 2- Enter the name of the database in the Db field. 3- Click on the Add Db button. The database will be added to the...

How can Remove a database?

Removing a database will delete that database from its online location. Be sure that you have saved a copy of the database if you want to keep any of the information in the database. Removing a...

How can I Create a PostgreSQL user?

You need to create a PostgreSQL user before that user is able to use the database. This does not automatically allow the user to use a database - you need to grant that user permission to the...

How can I Remove 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. 1- Click on the PostgreSQL databases button on the Cpanel home page. 2-...