Amazon Redshift will no longer support the use of Python UDFs after June 30, 2026.
We will start enforcing it in phases. For more information on the details of Python end of life
and migration options, 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;