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 when the row access policy was last altered.

DELETED

TIMESTAMP_LTZ

Date and time when the row access policy was dropped.

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.

Example

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

select *
from row_access_policies
order by created
;