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
SVV_RLS_ATTACHED_POLICY
Use SVV_RLS_ATTACHED_POLICY to view a list of all relations and users that have one or more row-level security policies attached on the currently connected database.
Only users with the sys:secadmin role can query this view.
Table columns
| Column name | Data type | Description |
|---|---|---|
| relschema | text | The name of the schema of the relation to which the row-level security policy is attached. |
| relname | text | The name of the relation to which the row-level security policy is attached. |
| relkind | text | The type of the object, such as table. |
| polname | text | The name of the row-level security policy that is attached to the relation. |
| grantor | text | The name of the user that has attached this policy. |
| grantee | text | The name of the user or role that this policy has been attached to. |
| granteekind | text | The type of grantee. Possible values are user or role. |
| is_pol_on | boolean | The parameter that indicates whether a row-level security policy is turned on or off on a table. Possible values are true and false. |
| is_rls_on | boolean | The parameter that indicates whether a row-level security is turned on or off on a table. Possible values are true and false. |
| rls_conjunction_type | character(3) | The parameter that indicates whether relation combine RLS policies with and or or. |
Sample query
The following example displays the result of the SVV_RLS_ATTACHED_POLICY.
--Inspect the policy in SVV_RLS_ATTACHED_POLICY SELECT * FROM svv_rls_attached_policy; relschema | relname | relkind | polname | grantor | grantee | granteekind | is_pol_on | is_rls_on | rls_conjuntion_type -----------+--------------------------+---------+-----------------+---------+----------+-------------+-----------+-----------+--------------------- public | tickit_category_redshift | table | policy_concerts | bob | analyst | role | True | True | and public | tickit_category_redshift | table | policy_concerts | bob | dbadmin | role | True | True | and
