PROFILES

Provides information about password policies that you set using the CREATE PROFILE statement. 提供通过 CREATE PROFILE 语句设置的密码策略信息。

图例

• ✅ = 字段存在于该版本
• ❌ = 字段不存在于该版本
• 备注列标注首次出现或类型变更的版本

字段名	Data Type	11.0.x	11.1.x	12.0.x	23.3.x	23.4.x	24.1.x	24.2.x	24.3.x	24.4.x	25.1.x	25.2.x	25.3.x	25.4.x	26.1.x	26.2.x	备注
FAILED_LOGIN_ATTEMPTS	VARCHAR	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
PASSWORD_GRACE_TIME	VARCHAR	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
PASSWORD_LIFE_TIME	VARCHAR	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
PASSWORD_LOCK_TIME	VARCHAR	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
PASSWORD_MAX_LENGTH	VARCHAR	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
PASSWORD_MIN_CHAR_CHANGE	VARCHAR	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
PASSWORD_MIN_DIGITS	VARCHAR	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
PASSWORD_MIN_LENGTH	VARCHAR	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
PASSWORD_MIN_LETTERS	VARCHAR	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
PASSWORD_MIN_LIFE_TIME	VARCHAR	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
PASSWORD_MIN_LOWERCASE_LETTERS	VARCHAR	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
PASSWORD_MIN_SYMBOLS	VARCHAR	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
PASSWORD_MIN_UPPERCASE_LETTERS	VARCHAR	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
PASSWORD_REUSE_MAX	VARCHAR	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
PASSWORD_REUSE_TIME	VARCHAR	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
PROFILE_ID	INTEGER	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
PROFILE_NAME	VARCHAR	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅