Snowflake Password Policy
snowflake.passwordPolicy MQL resource for querying Snowflake infrastructure with cnquery and cnspec.
Snowflake
Snowflake Password Policy
Use MQL in cnspec shell or policy:
snowflake.passwordPolicyMin version: 9.0.0Defaults:
nameRelationships
3 resources · 3 relationships·Click to select, expand fields to see properties.
Fields (18)
| Field | Type | Description |
|---|---|---|
commentrequired | string | Comment for the password policy |
createdAtrequired | time | When the password policy was created |
databaseNamerequired | string | Name of the database |
kindrequired | string | Name of the kind |
namerequired | string | Name of the password policy |
ownerrequired | string | Name of the owner |
passwordHistory | int | Number of recent passwords to retain |
passwordLockoutTimeMins | int | How long (in minutes) to lock out the user account |
passwordMaxAgeDays | int | Maximum number of days before password must be changed |
passwordMaxLength | int | Maximum number of characters for password |
passwordMaxRetries | int | Maximum number of attempts to enter a password before locking out the user account |
passwordMinAgeDays | int | Minimum number of days before password can be changed |
passwordMinLength | int | Minimum number of 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 |
passwordMinUpperCaseChars | int | Minimum number of uppercase characters for password |
schemaNamerequired | string | Name of the schema |