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

Check MySQL DB

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

phpMyAdmin

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

Delete PostgreSQL USER

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

Create MySQL Database

  Overview MySQL databases allow you to store lots of information in an easy to access...

Delete MySQL Database

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