DESC PASSWORD POLICY
显示 TiDB Cloud Lake 中特定密码策略的详细信息。有关密码策略属性的详细说明，请参见 密码策略属性。
语法
DESC PASSWORD POLICY <policy_name>
示例
CREATE PASSWORD POLICY SecureLogin
PASSWORD_MIN_LENGTH = 10;
DESC PASSWORD POLICY SecureLogin;
┌─────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┐
│ Property │ Value │ Default │ Description │
├───────────────────────────────┼─────────────┼──────────────────┼────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┤
│ NAME │ SecureLogin │ NULL │ Name of password policy. │
│ COMMENT │ │ NULL │ Comment of password policy. │
│ PASSWORD_MIN_LENGTH │ 10 │ 8 │ Minimum length of new password. │
│ PASSWORD_MAX_LENGTH │ 256 │ 256 │ Maximum length of new password. │
│ PASSWORD_MIN_UPPER_CASE_CHARS │ 1 │ 1 │ Minimum number of uppercase characters in new password. │
│ PASSWORD_MIN_LOWER_CASE_CHARS │ 1 │ 1 │ Minimum number of lowercase characters in new password. │
│ PASSWORD_MIN_NUMERIC_CHARS │ 1 │ 1 │ Minimum number of numeric characters in new password. │
│ PASSWORD_MIN_SPECIAL_CHARS │ 0 │ 0 │ Minimum number of special characters in new password. │
│ PASSWORD_MIN_AGE_DAYS │ 0 │ 0 │ Period after a password is changed during which a password cannot be changed again, in days. │
│ PASSWORD_MAX_AGE_DAYS │ 90 │ 90 │ Period after which password must be changed, in days. │
│ PASSWORD_MAX_RETRIES │ 5 │ 5 │ Number of attempts users have to enter the correct password before their account is locked. │
│ PASSWORD_LOCKOUT_TIME_MINS │ 15 │ 15 │ Period of time for which users will be locked after entering their password incorrectly many times (specified by MAX_RETRIES), in minutes. │
│ PASSWORD_HISTORY │ 0 │ 0 │ Number of most recent passwords that may not be repeated by the user. │
└─────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┘