Data TutorialsPostgreSQL

How to Create a User with pgAdmin

Posted on March 30, 2020

Connect to your PostgreSQL server instance using pgAdmin > right-click on ‘Group Roles’ and select ‘New Group Role’.

Connect to your PostgreSQL server

Give the role a descriptive name > click ‘OK’.  You do NOT need to create a password for the Group role; we will create a password for the Login role created later in this document.

No need to create a password for the Group role

Expand ‘Databases’ > right-click on the database you would like to connect to Chartio > select ‘Properties’.

Click the database you would like to conenct to Chartio

In the ‘Privileges’ tab select the newly created group from the ‘Role’ drop-down menu > check the ‘Connect’ box > click ‘Add/Change’ > click ‘OK’.

Click the Connect box in the Priviledges tab and choose OK

Click the expand arrow next to your database > expand ‘Schemas’ > right-click ‘public’ > select ‘Grant Wizard’.

Select Grant Wizard

On the ‘Selection’ tab click ‘Check All’.

Click Check All

In the ‘Privileges’ tab select the newly created group from the ‘Role’ drop-down menu > check the ‘Select’ box > click ‘Add/Change’ > click ‘OK’.

If your schema is not ‘public’, you will also need to grant USAGE permissions on the schema.

Grant USAGE permissions, if necessary

Under your server tree right-click ‘Login Roles’ > select ‘New Login Role’

Right-click to select New Login Role

Type a descriptive name for the user.

Add a name

On the ‘Definition’ tab enter a secure password.

Enter a password

On the ‘Role membership’ tab add the newly create group to the ‘Member’ window > click ‘OK’.

Final result

You have successfully created a new read-only user for your database.  Use the credentials created for the Login role when setting up your PostgreSQL connection for Chartio.

For information on creating a user with psql, see this article.

For more information on connecting your PostgreSQL database to Chartio, see our documentation.

Visual SQL Hero

Introducing Visual SQL

SQL may be the language of data, but not everyone can understand it. With our visual version of SQL, now anyone at your company can query data from almost any source—no coding required.

Learn about Visual SQL