需要 Workflow Manager 许可。
地理数据库管理员必须向将要访问 Workflow Manager (Classic) 工作空间的所有用户授予各表的特定权限。这可以通过创建数据库角色并向各个用户分配角色来实现。
在 pgAdmin 或 psql 中，可通过角色向 Workflow Manager (Classic) 工作空间表授予权限。
授予权限：
--This SQL query creates a script to revoke permissions granted directly to pmeditor, pmviewer users.
select 'REVOKE SELECT, INSERT, UPDATE, DELETE ON' || tableowner ||'.'|| tablename || 'FROM
pmeditor;' AS sqltxt from pg_tables where tableowner = 'wmx'
union all
select 'REVOKE SELECT, INSERT, UPDATE, DELETE ON' || tableowner ||'.'|| tablename || 'FROM
pmviewer;' AS sqltext from pg_tables where tableowner = 'wmx';
--This SQL query creates a script to grant permission to the roles.
--role_wmx_wmx_editor
select 'GRANT SELECT, INSERT, UPDATE, DELETE ON' || tableowner ||'.'|| 'TO
role_wmx_wmx_editor;' AS sqltext
from pg_tables
where tableowner = 'wmx';
--role_wmx_wmx_viewer
select 'GRANT SELECT ON' || tableowner ||'.'|| tablename || 'TO role_wmx_wmx_viewer;' AS sqltext
from pg_tables
where tableowner = 'wmx';
--Grant roles to editor and viewer users
GRANT role_wmx_wmx_editor TO pmeditor;
GRANT role_wmx_wmx_viewer TO pmviewer;