ROW_ACCESS_POLICIES View¶

This Account Usage view displays a row for each row access policy defined in your account.

Each row corresponds to a different row access policy.

Columns¶

Column Name	Data Type	Description
POLICY_NAME	TEXT	Name of the row access policy.
POLICY_ID	NUMBER	Internal/system-generated identifier for the row access policy.
POLICY_SCHEMA_ID	TEXT	Internal/system-generated identifier for the schema in which the policy resides.
POLICY_SCHEMA	TEXT	Schema to which the row access policy belongs.
POLICY_CATALOG_ID	TEXT	Internal/system-generated identifier for the database in which the policy resides.
POLICY_CATALOG	TEXT	Database to which the row access policy belongs.
POLICY_OWNER	TEXT	Name of the role that owns the row access policy.
POLICY_SIGNATURE	TEXT	Type signature of the row access policy’s arguments.
POLICY_RETURN_TYPE	TEXT	Return value data type.
POLICY_BODY	TEXT	Row access policy definition.
POLICY_COMMENT	TEXT	Comments entered for the row access policy (if any).
CREATED	TIMESTAMP_LTZ	Date and time when the row access policy was created.
LAST_ALTERED	TIMESTAMP_LTZ	Date and time when the row access policy was last altered.
DELETED	TIMESTAMP_LTZ	Date and time when the row access policy was dropped.
OWNER_ROLE_TYPE	TEXT	The type of role that owns the object, either `ROLE` or `DATABASE_ROLE`. Note that Snowflake returns NULL if you delete the object because there is no owner role for a deleted object.
OPTIONS	VARIANT	The value for the EXEMPT_OTHER_POLICIES property in the policy. If set to `TRUE`, the column returns `{ "EXEMPT_OTHER_POLICIES: "TRUE" }`. If the property is set to `FALSE` or not set at all, the column returns NULL.

Latency for the view may be up to 120 minutes (2 hours).
The view only returns rows if row access policies have been created in your account.

Obtain all of the row access policies created in your account, ordered by the timestamp on which the policy was created:

select policy_name, policy_signature, created
from row_access_policies
order by created
;

Copy