Skip to content

Creating Users in PostgreSQL

Prerequisites§

  • Determine user credentials (name and password).
  • Log on to the pgAdmin.

Process§

  1. In the pgAdmin, connect to the database server:

    1. In the Object Explorer, expand Servers. Then click the required server.

    2. If password request appears, in the text field of that dialog, enter the password for the user which name appears in the title.

    3. Select Save Password to avoid the dialog in the future.
    4. Click OK.

  2. Create a new account:

    1. In the Object Explorer menu, expand Servers → your PostgreSQL.

    2. Right click Login/Group Roles, then, in the action menu, point to Create, and then click Login/Group Role.
      The Group Role dialog appears.

  3. Set up the account:

    1. In the window that appears, go to the General tab.

    2. On the tab, in the Name field, enter the username.

  4. Set up user password:

    1. Go to the Definition tab.
    2. On the tab, in the Password field, enter the password.
  5. Activate the account:
    1. Go to the Privileges tab.
    2. On the tab, select the Can login control.
  6. In the window, click  Save.

Postrequisites§