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:
REVOKE <schema_name>_viewer from sdw_staff; |
or via the GUI: