Create PostgreSQL User

Overview

There are two primary steps when creating a PostgreSQL user. The first step is to create a username and password combination for the user. The second step is to add the user to the database you want the user to access.

Steps
  1. In the "New User" section, enter the username and password you want to use for this database in the "Username" and "Password" text boxes, respectively.
  2. Next, click on the Create User button.
  3. You should see the following statement:
    • "Added USERNAME with the password PASSWORD."
  4. Click on the Go Back link.
  5. Find the "Add User To Database" section. Select the user you created in Step 6 above from the "User" drop down menu. Then select the database you want to add the user to from the "Database" drop down menu.
  6. Next, click on the Submit button.
  7. You should see the following statement:
    • "User USERNAME was added to the database DATABASE."
  8. Click on the Go Back link.
  9. You should now see the user you created in Step 1 above in the "Users" column.
  • 84 Users Found This Useful
Was this answer helpful?

Related Articles

Repair DB (MySQL)

Overview You can repair your MySQL database by using the "Repair DB" feature in cPanel....

Remote (MySQL)

Overview Remote MySQL allows external web servers to access your MySQL databases by adding their...

phpPgAdmin

Overview phpPgAdmin is a web based database administration tool specifically for managing MySQL...

phpMyAdmin

Overview phpMyAdmin is a web based database administration tool specifically for managing MySQL...

Delete PostgreSQL USER

Overview There are two types of deleting users. One way is to delete a user from a database. The...

Powered by WHMCompleteSolution