解锁数据库用户并设置密码

-- 解锁 scott 用户
alter user scott account unlock;

-- 解锁 scott 用户  并设置密码为 password 
ALTER USER SCOTT IDENTIFIED BY PASSWORD ACCOUNT NULOCK;

 

--设置scott 用户的密码为 password 
ALTER USER SCOTT IDENTIFIED BY PASSWORD