Drop/Remove Access Policy

Comments

• Jim_Knicely Administrator

  November 2018

  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
  

  1
• richie1

  November 2018

  Awesome thanks for your help

  0