当前位置:数据库 > 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.  

 

 
Oracle
MySQL
Access
SQLServer
DB2
Excel
SQLite
SYBASE
Postgres
如果你遇到数据库难题:
请访问www.zzzyk.com 试试
CopyRight © 2012 站长网 编程知识问答 www.zzzyk.com All Rights Reserved
部份技术文章来自网络,