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.
Code Block | ||
---|---|---|
| ||
REVOKE USAGE ON SCHEMA <schema_name> FROM staff; |