Доступно с лицензией Data Reviewer.
User permissions need to be granted to the schema tables for those who will edit or view the results in the Reviewer workspace. В pgAdmin или psql предоставьте права доступа к таблицам рабочей области Reviewer, используя роли.
Этот запрос SQL создает скрипт для удаления прав доступа, предоставленных непосредственно пользователям pmeditor и pmviewer.
select 'REVOKE SELECT, INSERT, UPDATE, DELETE ON'|| tableowner || '.' || tablename || 'FROM
pmeditor;' AS sqltext from pg_tables where tableowner = 'rev'
union all
select 'REVOKE SELECT, INSERT, UPDATE, DELETE ON' || tableowner || '.' || tablename || 'FROM
pmviewer;' AS sqltext from pg_tables where tableowner = 'rev';
Этот SQL запрос создает скрипт для предоставления прав доступа ролям.
--role_rev_rev_editor
select 'GRANT SELECT, INSERT, UPDATE, DELETE ON' || tableowner || '.' || tablename || 'TO
role_rev_rev_editor;' AS sqltext
from pg_tables
where tableowner = 'rev';
--role_rev_rev_viewer
select 'GRANT SELECT ON' || tableowner || '.' || tablename || 'TO role_rev_rev_viewer; 'AS sqltxt
from pg_tables
where tableowner = 'rev';
--Grant roles to editor and viewer users
GRANT role_rev_rev_editor TO pmeditor;
GRANT role_rev_rev_viewer TO pmviewer;