feat: PASSWORD POLICY

[BohuTANG]

Summary

Databend currently lacks a SQL user policy for password management, such as denying access after incorrect password attempts and setting password complexity requirements.

CREATE PASSWORD POLICY [ IF NOT EXISTS ] <name>
  [ PASSWORD_MIN_LENGTH = <integer> ]
  [ PASSWORD_MAX_LENGTH = <integer> ]
  [ PASSWORD_MIN_UPPER_CASE_CHARS = <integer> ]
  [ PASSWORD_MIN_LOWER_CASE_CHARS = <integer> ]
  [ PASSWORD_MIN_NUMERIC_CHARS = <integer> ]
  [ PASSWORD_MIN_SPECIAL_CHARS = <integer> ]
  [ PASSWORD_MIN_AGE_DAYS = <integer> ]
  [ PASSWORD_MAX_AGE_DAYS = <integer> ]
  [ PASSWORD_MAX_RETRIES = <integer> ]
  [ PASSWORD_LOCKOUT_TIME_MINS = <integer> ]
  [ PASSWORD_HISTORY = <integer> ]
  [ COMMENT = '<string_literal>' ]

Reference: https://docs.snowflake.com/en/sql-reference/sql/create-password-policy

AnalyzedPassword: https://crates.io/crates/passwords

tasks:

• [x] create/alter/drop/desc/show password policy
• [ ] check whether the password is valid

[BohuTANG]

cc @TCeason