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:
- Expand the Server details for the SDW server and login using a admin user.
- Expand the Group Roles.
- Right click on sdw_staff and select properties
- select the Role membership tab.
- Select the relevant role (e.g. planning_viewer) in the Members box and click << to add it to the Not Member box.