Schema:

ACCOUNT_USAGE

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 the object was last altered. See Usage Notes.

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.

Usage Notes

  • 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.

  • The LAST_ALTERED column is updated when the following operations are performed on an object:

    • DDL operations.

    • DML operations (for tables only).

    • Background maintenance operations on metadata performed by Snowflake.

Example

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