Top
Enterprise Postgres 16 Security Operation Guide

7.4.5 Deleting Confidentiality Matrix

Delete the confidentiality matrix as follows.

select pgx_drop_confidential_matrix('matrix_foo', false, false)

By specifying a second or third argument, you can choose to delete all confidentiality levels and confidentiality groups added to the confidentiality matrix, or remove confidentiality group roles. Confidentiality group roles that were not deleted can be identified using the previously mentioned naming convention. No matter what you choose, the roles registered in the confidentiality group will not be deleted. The above example simply deletes the confidentiality matrix only.