1 show user
2 conn / as sysdba
3:alter user hr account unlock

baocuo ORA-01017

 

1:conn / as sysdba

2: alter user hr identified by hr ;

 


conn hr/hr

 

 

以上是关于hr的用户解锁的例子,(初学者)。

```````````````````````````````````````````````````````````````````````````````````````````````````````

1:show user :查看当前的用户

 

2:desc dba_users;

3:select username, account_status from dba_users order by username;

可以查看用户的权限

4:alter user hr account unlock;(这是解锁)

更改hr用户的权限

5:alter user hr identified by hr;

更改hr用户的密码

posted on 2016-09-07 00:31  沫小辉  阅读(532)  评论(0编辑  收藏  举报