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
Where
nameis the name of the policy to be removed.table_nameis the name of the table that the policy is on.CASCADE/RESTRICTdon't have any effect because table policies don't have any dependent objects.
Example
- Drop a policy.
yugabyte=# DROP POLICY p1 ON table_foo;