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