1、切换到sys用户。命令: conn /as sysdba查看hr用户状态。命令:select username,account_status from dba_users where username='HR';可以看到状态为:加锁/密码过期
2、1·为hr解锁命令:alter user hr account unlock;
3、1·为hr设置密码命令:alter user hr identified by 新密码;状态:open
4、1·为hr加锁2·为hr设置密码过期3·查看hr状态
5、解锁并更改密码命令:alter user hr account unlock identified by 新密码;
6、切换到hr用户。命令:conn hr/密码查看当前登陆用户。命令:show user