SVV_RLS_POLICY

Use SVV_RLS_POLICY to view a list of all row-level security policies created on the Amazon Redshift cluster.

SVV_RLS_POLICY is visible to all users. Superusers can see all rows; regular users can see only their own data. For more information, see Visibility of data in system tables and views.

Table columns

Column name	Data type	Description
poldb	text	The name of the database in which the row-level security policy is created.
polname	text	The name of the row-level security policy.
polalias	text	The table alias used in the policy definition.
polatts	text	The attributes provided to the policy definition.
polqual	text	The policy condition provided in the USING clause of the CREATE POLICY statement.
polenabled	boolean	Whether the policy is turned on globally.
polmodifiedby	text	The name of the user that created or modified the policy most recently.
polmodifiedtime	timestamp	The timestamp of when the policy is created or last modified.

Sample query

The following example displays the result of the SVV_RLS_POLICY.

-- Create some policies.
CREATE RLS POLICY pol1 WITH (a int) AS t USING ( t.a IS NOT NULL );
CREATE RLS POLICY pol2 WITH (c varchar(10)) AS t USING ( c LIKE '%public%');

-- Inspect the policy in SVV_RLS_POLICY
SELECT * FROM svv_rls_policy;

 poldb | polname | polalias |                     polatts                      |                polqual                | polenabled | polmodifiedby |   polmodifiedtime   
-------+---------+----------+--------------------------------------------------+---------------------------------------+------------+---------------+---------------------
 my_db | pol1    | t        | [{"colname":"a","type":"integer"}]               | "t"."a" IS NOT NULL                   | t          | policy_admin  | 2022-02-11 14:40:49
 my_db | pol2    | t        | [{"colname":"c","type":"character varying(10)"}] | "t"."c" LIKE CAST('%public%' AS TEXT) | t          | policy_admin  | 2022-02-11 14:41:28