Top
Enterprise Postgres 16 Security Operation Guide

7.4.10 Revoking Confidentiality Privileges

Revoke confidentiality privileges from confidentiality groups as follows. Specify the confidentiality object and confidentiality group and the privileges to revoke in JSON format. The following example revokes INSERT and DELETE privileges for table-type confidentiality objects belonging to 'level1' from 'group1'.

select pgx_revoke_confidential_privilege('matrix_foo','level1', 'group1',  '{"table":["INSERT","DELETE"]}')