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

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

Usage Notes¶

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