You have successfully created a new read-only user for your database. On the ‘Role membership’ tab add the newly create group to the ‘Member’ window > click ‘OK’. On the ‘Definition’ tab enter a secure password.
Under your server tree right-click ‘Login Roles’ > select ‘New Login Role’ If your schema is not ‘public’, you will also need to grant USAGE permissions on the schema. In the ‘Privileges’ tab select the newly created group from the ‘Role’ drop-down menu > check the ‘Select’ box > click ‘Add/Change’ > click ‘OK’. On the ‘Selection’ tab click ‘Check All’. In the ‘Privileges’ tab select the newly created group from the ‘Role’ drop-down menu > check the ‘Connect’ box > click ‘Add/Change’ > click ‘OK’.Ĭlick the expand arrow next to your database > expand ‘Schemas’ > right-click ‘public’ > select ‘Grant Wizard’. 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.Įxpand ‘Databases’ > right-click on the database you would like to connect to Chartio > select ‘Properties’. Give the role a descriptive name > click ‘OK’. Connect to your PostgreSQL server instance using pgAdmin > right-click on ‘Group Roles’ and select ‘New Group Role’.
