DROP POLICY

This page documents the preview version (v2.23). Preview includes features under active development and is for development and testing only. For production, use the stable version (v2024.1). To learn more, see Versioning.

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