SVV_MASKING_POLICY

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.