当前位置:数据库 > Oracle >>

启用密码管理之前创建的用户连接Oracle报ORA-28002处理一则

启用密码管理之前创建的用户连接Oracle报ORA-28002处理一则
 
  处理方法其实很简单、只要:
     alter user <username> identified by <same password>; 
 这个操作后,恢复正常了
     
     下面作个简单测试:
[plain]
SQL> conn hr/hr  
ERROR:  
ORA-28002: the password will expire within 2 days  
  
  
Connected.  
SQL> conn / as sysdba  
Connected.  
SQL> alter user hr identified by hr;  
  
User altered.  
  
SQL> conn hr/hr  
Connected.  
SQL> conn scott/tiger  
ERROR:  
ORA-28002: the password will expire within 2 days  
  
  
Connected.  
SQL> conn / as sysdba  
Connected.  
SQL> alter user scott identified by tiger;  
  
User altered.  
  
SQL> conn scott/tiger  
Connected.  

 

 
CopyRight © 2022 站长资源库 编程知识问答 zzzyk.com All Rights Reserved
部分文章来自网络,