DROP POLICY removes 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;