oracle 11g密码过期但不想更新密码

叁歲伎倆 2022-08-05 11:14 121阅读 0赞

SQL> select \* from v$version;  
BANNER  
\--------------------------------------------------------------------------------  
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production  
PL/SQL Release 11.2.0.1.0 - Production  
CORE    11.2.0.1.0      Production  
TNS for 64-bit Windows: Version 11.2.0.1.0 - Production  
NLSRTL Version 11.2.0.1.0 - Production  
  
  
**SELECT username,PROFILE FROM dba\_users; --先看此用户下的资源计划**  
USERNAME     PROFILE  
\---------   ----------  
GG  DEFAULT  
  
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  
  
  
**ALTER PROFILE DEFAULT LIMIT PASSWORD\_LIFE\_TIME UNLIMITED;--修改资源计划**  
  
  
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      UNLIMITED  
  
  
**alter user GG identified by GG\_1000;--还是想用原来的密码，但是报错**  
\*  
ERROR at line 1:  
ORA-28007: the password cannot be reused  
  
  
**select profile, resource\_name, limit  
  from dba\_profiles  
 where resource\_name in('PASSWORD\_REUSE\_TIME','PASSWORD\_REUSE\_MAX')  
   and profile = 'DEFAULT';**  
PROFILE      RESOURCE\_NAME           LIMIT  
\---------  -----------------     -------------   
DEFAULT     PASSWORD\_REUSE\_TIME  UNLIMITED  
DEFAULT   PASSWORD\_REUSE\_MAX   5  
  
**ALTER PROFILE DEFAULT LIMIT PASSWORD\_REUSE\_MAX UNLIMITED;  
ALTER USER GG ACCOUNT UNLOCK;**