Disponible con una licencia de Workflow Manager.
El administrador de geodatabase debe otorgar permisos específicos para las tablas a todos los usuarios que deseen acceder al espacio de trabajo de Workflow Manager (Classic). Esto se puede lograr creando roles de base de datos y asignando los roles a los usuarios individuales.
En pgAdmin o psql, conceda permisos a las tablas del espacio de trabajo de Workflow Manager (Classic) usando roles.
Conceder privilegios:
--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;