Allow Users access to Schema from Desktop GIS v2.0

Owned by Kim Stimpson
Last updated: 05 Oct, 2023
1 min read

If a user requires access to a schema in the SDW from a Desktop GIS such as QGIS then they need permission to that schema.

To edit the data:

GRANT schema_editor to a_bloggs

To view data in a restricted schema:

GRANT schema_viewer to a_bloggs

If a user wishes to view data in a non-restricted schema then you don’t need to do anything as they already have access.