Allow Users access to Views using multiple schemas in iShare v2.0

Owned by Kim Stimpson
Last updated: 07 Dec, 2023
1 min read

In the iShare SDW tables are currently owned by the schema_owner role. Access rights are passed from schema_viewer to the ishare_reader and then onto isharewebservice_gis or isharewebservice_maps.

If you creating views using multiple schemas then the owner of the view must have select permission on the tables in the view definition. If this is not given then PostgreSQL will error with a permission denied for the second table. To overcome this you need to:

GRANT SELECT ON TABLE second_schema.second_table TO first_schema_owner; --OR GRANT second_schema_viewer TO first_schema_owner;