Loading

OracleXE 11g user莫名过期

参考大大的

环境sqlplus

1.sysdba登陆

1 SQL>conn sys as sysdba
2 password

2.查看用户状态

SQL>select username,account_status,lock_date from dba_users;

3.解决问题

  • 单纯被锁
    SQL>alter user user_name account unlock;
    SQL>commit;

     

  • 用户过期
    ;以HR用户为例
    SQL>UPDATE USER$ SET ASTATUS=0 WHERE NAME='HR';
    ;修改状态
    SQL>select username,account_status from dba_users where username in('SYS','HR');
    ;查看状态
    SQL>select name,ASTATUS,password from user$ where name IN('SYS','HR');
    ;查看密码
    SQL>alter user HR identified by values '4C6D73C3E8B0F0DA';
    ;以密文修改

    ok~~

posted @ 2017-03-26 21:14  ArkiWang  阅读(231)  评论(0编辑  收藏  举报