# PasswordPolicy

[Snowflake Documentation](https://docs.snowflake.com/en/sql-reference/sql/create-password-policy)

Defines the rules and constraints for creating and managing passwords within the system, ensuring they meet specific security standards.

## Examples

### Python

```python
password_policy = PasswordPolicy(
    name="some_password_policy",
    password_min_length=10,
    password_max_length=128,
    password_min_upper_case_chars=2,
    password_min_lower_case_chars=2,
    password_min_numeric_chars=2,
    password_min_special_chars=1,
    password_min_age_days=1,
    password_max_age_days=60,
    password_max_retries=3,
    password_lockout_time_mins=30,
    password_history=5,
    comment="Strict policy for admin accounts.",
    owner="SYSADMIN"
)
```

### YAML

```yaml
password_policies:
  - name: some_password_policy
    password_min_length: 10
    password_max_length: 128
    password_min_upper_case_chars: 2
    password_min_lower_case_chars: 2
    password_min_numeric_chars: 2
    password_min_special_chars: 1
    password_min_age_days: 1
    password_max_age_days: 60
    password_max_retries: 3
    password_lockout_time_mins: 30
    password_history: 5
    comment: Strict policy for admin accounts
    owner: SYSADMIN
```

## Fields

* `name` (string, required) - The name of the password policy.
* `password_min_length` (int) - The minimum length of the password. Defaults to 8.
* `password_max_length` (int) - The maximum length of the password. Defaults to 256.
* `password_min_upper_case_chars` (int) - The minimum number of uppercase characters in the password. Defaults to 1.
* `password_min_lower_case_chars` (int) - The minimum number of lowercase characters in the password. Defaults to 1.
* `password_min_numeric_chars` (int) - The minimum number of numeric characters in the password. Defaults to 1.
* `password_min_special_chars` (int) - The minimum number of special characters in the password. Defaults to 0.
* `password_min_age_days` (int) - The minimum age of the password in days. Defaults to 0.
* `password_max_age_days` (int) - The maximum age of the password in days. Defaults to 90.
* `password_max_retries` (int) - The maximum number of login retries before the account is locked. Defaults to 5.
* `password_lockout_time_mins` (int) - The time in minutes an account remains locked after exceeding retry limit. Defaults to 15.
* `password_history` (int) - The number of unique new passwords before an old password can be reused.
* `comment` (string) - A comment about the password policy.
* `owner` (string or [Role](/titan-core/resources/role.md)) - The owner role of the password policy. Defaults to "SYSADMIN".


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://titan-core.gitbook.io/titan-core/resources/password_policy.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.