Drop/Remove Access Policy

richie1

Hello, I am struggling to find out how to drop an access policy, can anyone help please?

Thanks

Jim_Knicely

Use DROP ACCESS POLICY...

See:
https://www.vertica.com/docs/9.1.x/HTML/index.htm#Authoring/SQLReferenceManual/Statements/DROPACCESSPOLICY.htm

Example:

dbadmin=> CREATE TABLE test (c INT);
CREATE TABLE

dbadmin=> CREATE ACCESS POLICY ON test
dbadmin->   FOR COLUMN c
dbadmin->   CASE WHEN c = 1 THEN c ELSE NULL END
dbadmin->   ENABLE;
CREATE ACCESS POLICY

dbadmin=> DROP ACCESS POLICY ON test FOR COLUMN c;
DROP ACCESS POLICY

richie1

Awesome thanks for your help