Schema:: ACCOUNT_USAGE

PRIVACY_POLICIES view¶

This Account Usage view provides the privacy policies in your account.

Each row in this view corresponds to a different privacy policy.

Columns¶

Column Name	Data Type	Description
`policy_id`	NUMBER	Internal/system-generated identifier for the privacy policy.
`policy_name`	VARCHAR	Name of the privacy policy.
`policy_schema_id`	NUMBER	Internal/system-generated identifier for the schema in which the policy resides.
`policy_schema`	VARCHAR	Schema that contains the privacy policy.
`policy_catalog_id`	NUMBER	Internal/system-generated identifier for the database in which the policy resides.
`policy_catalog`	VARCHAR	Database to which the privacy policy belongs.
`policy_owner`	VARCHAR	Name of the role that owns the privacy policy.
`policy_signature`	VARCHAR	Type signature of the privacy policy’s arguments.
`policy_return_type`	VARCHAR	Return value data type.
`policy_body`	VARCHAR	Privacy policy definition.
`policy_comment`	VARIANT	Comments entered for the privacy policy (if any).
`created`	TIMESTAMP_LTZ	Date and time when the privacy policy was created.
`last_altered`	TIMESTAMP_LTZ	Date and time when the privacy policy was last altered.
`deleted`	TIMESTAMP_LTZ	Date and time when the privacy policy was dropped.
`owner_role_type`	VARCHAR	The type of role that owns the object, for example `ROLE`. . If a Snowflake Native App owns the object, the value is `APPLICATION`. . Snowflake returns NULL if you delete the object because a deleted object does not have an owner role.

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.