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用户的密码