Restricting a Schema in the SDW V1.5

In the Astun Spatial Data Warehouse there is a Staff role which everyone inherits from and all unrestricted schemas have Usage granted to Staff Removing this makes the schema restricted only to those who inherit the <schema_name>_viewer or <schema_name>_editor role.

Restrict a Schema
REVOKE USAGE ON SCHEMA <schema_name> FROM staff;