oracle数据库如何解锁修改scott用户

Question

如题所述

Answer 1

解锁scott用户：
alter user scott account unlock;
修改密码并解锁：
alter user scott account unlock identified by xxxxxx;

Answer 2

登录有dba权限的账号进行解锁
方法一：
alter user scott account unlock identified by tiger;
方法二：
alter user scott account unlock;
alter user scott identified by tiger;本回答被网友采纳