Page Comparison

...

GRANT mytest_editor to isharewebservice_gis;
GRANT mytest_owner to editor;

Apply permissions to all schemas

If you wish to apply these permissions to all schemas in the SDW you can generate the commands using the following SQL. Save to a file and run in a pgAdmin query window or via psql.exe.

SELECT ('GRANT ' || schema_name || '_editor to isharewebservice_gis; GRANT ' || schema_name || '_owner to editor;') as commands FROM information_schema.schemata where schema_owner like '%owner' order by schema_name