Assigning Access Rights to a Private Schema V1.5

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