Oracle设置用户密码不过期
emmm...也不知道为啥....密码不能过期...虽然不符合审计要求,但是用的爽啊....
version:Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit
0、检查用户密码过期时间
SQL> SELECT USERNAME,ACCOUNT_STATUS,EXPIRY_DATE,DEFAULT_TABLESPACE,TEMPORARY_TABLESPACE FROM DBA_USERS WHERE USERNAME ='USER1';
USERNAME ACCOUNT_STATUS EXPIRY_DATE DEFAULT_TABLESPACE TEMPORARY_TABLESPACE
------------------------------ -------------------------------- ------------ ------------------------------ ------------------------------
USER1 OPEN 21-DEC-23 USER1 TEMPTS1
1、检查用户所属 PROFILE
SELECT USERNAME,PROFILE FROM DBA_USERS WHERE USERNAME='USER1';
USERNAME PROFILE
------------------------------ ------------------------------
USER1 DEFAULT
- 检查 DEFAULT 的密码策略 PASSWORD_LIFE_TIME
SELECT * FROM DBA_PROFILES S WHERE S.PROFILE='DEFAULT' AND RESOURCE_NAME='PASSWORD_LIFE_TIME';
PROFILE RESOURCE_NAME RESOURCE LIMIT
------------------------------ -------------------------------- -------- ----------------------------------------
DEFAULT PASSWORD_LIFE_TIME PASSWORD 180
3、修改密码过期天数为 UNLIMITED
ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
4、再次检查用户密码过期时间, EXPIRY_DATE 为空了
SQL> SELECT USERNAME,ACCOUNT_STATUS,EXPIRY_DATE,DEFAULT_TABLESPACE,TEMPORARY_TABLESPACE FROM DBA_USERS WHERE USERNAME ='USER1';
USERNAME ACCOUNT_STATUS EXPIRY_DATE DEFAULT_TABLESPACE TEMPORARY_TABLESPACE
------------------------------ -------------------------------- ------------ ------------------------------ ------------------------------
USER1 OPEN USER1 TEMPTS1