Schema:

ACCOUNT_USAGE

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.