向 PostgreSQL 中的 Reviewer 工作空间组件授予权限

需要 Data Reviewer 许可。

需要向要在 Reviewer 工作空间中编辑或查看结果的人员授予对表方案的用户权限。 在 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;