Hello, I am struggling to find out how to drop an access policy, can anyone help please?
Use DROP ACCESS POLICY...
dbadmin=> CREATE TABLE test (c INT);
dbadmin=> CREATE ACCESS POLICY ON test
dbadmin-> FOR COLUMN c
dbadmin-> CASE WHEN c = 1 THEN c ELSE NULL END
CREATE ACCESS POLICY
dbadmin=> DROP ACCESS POLICY ON test FOR COLUMN c;
DROP ACCESS POLICY
Awesome thanks for your help