- Schema:
POLICY_REFERENCES View¶
This Account Usage view can be used to identify the objects and columns on which a masking policy is set or the tables and views in which a row access policy is set.
The view is complementary to the information schema table function POLICY_REFERENCES.
Columns¶
Column Name |
Data Type |
Description |
|---|---|---|
POLICY_DB |
TEXT |
The database in which the policy is set. |
POLICY_SCHEMA |
TEXT |
The schema in which the policy is set. |
POLICY_ID |
NUMBER |
Internal/system-generated identifier for the policy. |
POLICY_NAME |
TEXT |
The name of the policy. |
POLICY_KIND |
TEXT |
The type of policy. |
REF_DATABASE_NAME |
TEXT |
The name of the database containing an object that the queried object references. |
REF_SCHEMA_NAME |
TEXT |
The name of the schema containing an object that the queried object references. |
REF_ENTITY_NAME |
NUMBER |
The name of the object (i.e. table_name, view_name, external_table_name) on which the policy is set. |
REF_ENTITY_DOMAIN |
TEXT |
The object type (i.e. table, view) on which the policy is set. |
REF_COLUMN_NAME |
TEXT |
The column name on which the policy is set. |
REF_ARG_COLUMN_NAMES |
TEXT |
Returns NULL for rows in the query result in which a Column-level Security masking policy is set. |
Usage Notes¶
Latency for the view may be up to 120 minutes (2 hours).
The view only displays objects for which the current role for the session has been granted access privileges.