Schema:: ACCOUNT_USAGE

PASSWORD_POLICIES view¶

This Account Usage view provides the user-defined password policies in your account.

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

Columns¶

Column Name	Data Type	Description
NAME	TEXT	Name of the policy.
ID	NUMBER	Internal/system-generated identifier for the password policy.
SCHEMA_ID	TEXT	Internal/system-generated identifier for the schema in which the policy resides.
SCHEMA	TEXT	Schema to which the password policy belongs.
DATABASE_ID	TEXT	Internal/system-generated identifier for the database in which the policy resides.
DATABASE	TEXT	Database to which the password policy belongs.
OWNER	TEXT	Name of the role that owns the password policy.
OWNER_ROLE_TYPE	TEXT	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.
PASSWORD_MIN_LENGTH	INT	Minimum password length allowed for the policy.
PASSWORD_MAX_LENGTH	INT	Maximum password length allowed for the policy.
PASSWORD_MIN_UPPER_CASE_CHARS	INT	Minimum number of uppercase characters allowed for the policy.
PASSWORD_MIN_LOWER_CASE_CHARS	INT	Minimum number of lowercase characters allowed for the policy.
PASSWORD_MIN_NUMERIC_CHARS	INT	Minimum number of numeric characters allowed for the policy.
PASSWORD_MIN_SPECIAL_CHARS	INT	Minimum number of special characters allowed for the policy.
PASSWORD_MIN_AGE_DAYS	INT	The number of days a user must wait before a recently changed password can be changed again.
PASSWORD_MAX_AGE_DAYS	INT	Maximum number of days password is valid.
PASSWORD_MAX_RETRIES	INT	Maximum number of password attempts allowed.
PASSWORD_LOCKOUT_TIME_MINS	INT	Minimum time in minutes before password can be retried.
COMMENT	TEXT	Comments entered for the password policy (if any).
CREATED	TIMESTAMP_LTZ	Date and time when the password policy was created.
LAST_ALTERED	TIMESTAMP_LTZ	Date and time when the password policy was last altered.
DELETED	TIMESTAMP_LTZ	Date and time when the password policy was dropped.
PASSWORD_HISTORY	INT	The number of the most recent passwords that Snowflake stores. These stored passwords cannot be repeated when a user updates their password value.

Usage notes¶

Latency for the view may be up to 120 minutes (2 hours).

The LAST_ALTERED column is updated when the following operations are performed on an object:
- DDL operations.
- DML operations (for tables only). This column is updated even when no rows are affected by the DML statement.
- Background maintenance operations on metadata performed by Snowflake.