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 | database_name.policy_name } [ CASCADE | RESTRICT ]
Parameters
- IF EXISTS
-
A clause that indicates if the specified policy already exists.
- policy_name
-
The name of the policy.
- database_name
-
The name of the database from where the policy to be dropped. The database can be the connected database or a database that supports Amazon Redshift federated permissions.
- 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.
For the usage of DROP RLS POLICY on Amazon Redshift Federated Permissions Catalog, see Managing access control with Amazon Redshift federated permissions.
Examples
The following example drops the row-level security policy.
DROP RLS POLICY policy_concerts;
