Creating a user with pgAdmin

Data Sources

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.


Related Data Sources Help Articles

See more