SVV_RLS_ATTACHED_POLICY - Amazon Redshift
Table columnsSample query
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

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