DROP POLICY

Synopsis

Use the DROP POLICY statement to remove the specified row level security policy from the table. Note that if all policies for a table are removed and the table still has ENABLE ROW LEVEL SECURITY, then a default deny all policy will be applied for the table.

Syntax

drop_policy ::= DROP POLICY [ IF EXISTS ] name ON table_name 
                [ CASCADE | RESTRICT ]

drop_policy

DROPPOLICYIFEXISTSnameONtable_nameCASCADERESTRICT

Where

  • name is the name of the policy to be removed.
  • table_name is the name of the table that the policy is on.
  • CASCADE / RESTRICT don't have any effect because table policies don't have any dependent objects.

Example

  • Drop a policy.
yugabyte=# DROP POLICY p1 ON table_foo;

See also