Top
Enterprise Postgres 17 Security Operation Guide

7.4.12 Removing Roles from Confidentiality Groups

Remove the role from the confidentiality group as follows. Specify the roles to remove in JSON format. The following example removes roles 'role1' and 'role2' from confidentiality group 'group1'.

select pgx_remove_role_from_confidential_group('matrix_foo', 'group1', '["role1","role2"]')