Restricting a Schema in the SDW v2.0

In the Astun Spatial Data Warehouse there is a sdw_staff role which users are given. If a schema is created with staffAccess is true then sdw_staff is given the role <schema>_viewer. To remove public access from a schema we need to revoke the sdw_staff role.

You can do this in pgAdmin III (logged in as an admin user) either via SQL using the command below:

Restrict a Schema
REVOKE <schema_name>_viewer from sdw_staff; 

or via the GUI:

  1. Expand the Server details for the SDW server and login using a admin user.
  2. Expand the Group Roles.
  3. Right click on sdw_staff and select properties
  4. select the Role membership tab.
  5. Select the relevant role (e.g. planning_viewer) in the Members box and click << to add it to the Not Member box.