Page Comparison

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 fro from a schema , revoke the role  <schema>_viewer from we need to revoke the sdw_staff ;role.

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

REVOKE <schema_name>_viewer from sdw_staff; 

or via the GUI 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 R ole 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.

...