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.
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

Create MySQL User

Overview There are two primary steps when creating a MySQL user. The first step is to...

Repair DB (MySQL)

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

Check MySQL DB

You can check to see if your MySQL database is running properly using the "Check DB"...

phpPgAdmin

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

Delete PostgreSQL Database

Overview You can easily delete a PostgreSQL database from your web hosting account. Follow...