1. 修改用户密码
alter user scott identified by 123
2. 授予用户权限
grant connect,resource to scott
3. 解锁用户
alter user scott account unlock
来源: http://www.bubuko.com/infodetail-1956659.html