AttentionThis page documents an earlier version. Go to the latest (v2.3) version.
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.
drop_policy ::= DROP POLICY [ IF EXISTS ] name ON table_name [ CASCADE | RESTRICT ]
nameis the name of the policy to be removed.
table_nameis the name of the table that the policy is on.
RESTRICTdon't have any effect since table policies don't have any dependencies.
- Drop a policy.
yugabyte=# DROP POLICY p1 ON table_foo;