- Run pgAdmin III
- Expand the Server details for the SDW server and login using a superuser or administrator account.
- Expand the Login Roles to show the entries.
- Right-click on the user to which you wish to assign Viewing or Editing rights and select Properties.
- Select the Role membership tab.
- Select the relevant role in the Not Member box and click >> to add to the Member box. For restricted read-only access a user requires the <schemaname>_viewer role and for read/write access a user requires the <schemaname>_editor role (replacing <schemaname> with the name of the private schema to which you wish to give the User access). E.g. in the following screenshot we are granting editing rights to the grounds schema.
- Click OK.