Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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.

Unfortunately this is not enough when multiple schemas are used in views. In this case 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:

...