Amazon Redshift will no longer support the creation of new Python UDFs starting November 1, 2025.
If you would like to use Python UDFs, create the UDFs prior to that date.
Existing Python UDFs will continue to function as normal. For more information, see the
blog post
DROP RLS POLICY
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;
