snowflake.passwordPolicy
Description
Snowflake Password Policy
Fields
| ID | TYPE | DESCRIPTION |
|---|---|---|
| name | string | Name of the password policy |
| databaseName | string | Name of the database |
| schemaName | string | Name of the schema |
| kind | string | Name of the kind |
| owner | string | Name of the owner |
| comment | string | Comment for the password policy |
| createdAt | time | When the password policy was created |
| passwordMinLength | int | Minimum number of characters for password |
| passwordMaxLength | int | Maximum number of characters for password |
| passwordMinUpperCaseChars | int | Minimum number of uppercase characters for password |
| passwordMinLowerCaseChars | int | Minimum number of lowercase characters for password |
| passwordMinNumericChars | int | Minimum number of numeric characters for password |
| passwordMinSpecialChars | int | Minimum number of special characters for password |
| passwordMinAgeDays | int | Minimum number of days before password can be changed |
| passwordMaxAgeDays | int | Maximum number of days before password must be changed |
| passwordMaxRetries | int | Maximum number of attempts to enter a password before locking out the user account |
| passwordLockoutTimeMins | int | How long (in minutes) to lock out the user account |
| passwordHistory | int | Number of recent passwords to retain |