Granting privileges to the Reviewer workspace components in PostgreSQL

Available with Data Reviewer license.

User permissions need to be granted to the schema tables for those who will edit or view the results in the Reviewer workspace. In pgAdmin or psql, grant permissions to the Reviewer workspace tables using roles.

Note:

Copying and pasting the examples may cause syntax errors.

This SQL query creates a script to revoke permissions granted directly to pmeditor and pmviewer users.

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';

This SQL query creates a script to grant permissions to the roles.

--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;