Drops a row-level security policy for all tables in all databases.
Superusers and users or roles that have the sys:secadmin role can drop a policy.
Syntax
DROP RLS POLICY [ IF EXISTS ] policy_name [ CASCADE | RESTRICT ]
Parameters
- IF EXISTS
-
A clause that indicates if the specified policy already exists.
- policy_name
-
The name of the policy.
- CASCADE
-
A clause that indicates to automatically detach the policy from all attached tables before dropping the policy.
- RESTRICT
-
A clause that indicates not to drop the policy when it is attached to some tables. This is the default.
Examples
The following example drops the row-level security policy.
DROP RLS POLICY policy_concerts;