Assigning Access Rights to a Private Schema v2.0

  1. Run pgAdmin III

  2. Expand the Server details for the SDW server and login using a superuser or administrator account.

  3. Expand the Login Roles to show the entries.

  4. Right-click on the user to which you wish to assign Viewing or Editing rights and select Properties.

  5. Select the Role membership tab.

  6. 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.



  7. Click OK.