SVV_MASKING_POLICY - Amazon Redshift
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).


Use SVV_MASKING_POLICY to view all masking policies created on the cluster.

Only superusers and users with the sys:secadmin role can view SVV_MASKING_POLICY. Regular users will see 0 rows.

Table columns

Column name Data type Description
policy_database text The name of the database in which the masking policy was created.
policy_name text The name of the masking policy.
input_columns text The attributes provided in the WITH clause of CREATE POLICY statement.
policy_expression text The masking expression used in the policy.
policy_modified_by text The name of the user who last modified the policy.
policy_modified_time timestamp The timestamp of when the policy was created or last modified.