用户和锁

Oracle视频教程链接：http://school.itzcn.com/video-vid-1089-spid-35.html

查看哪些用户是否被锁

1.以sysdba进入sqlplus :  sqlplus / as sysdba;
2. 执行命令查询：   SELECT  username,account_status FROM dba_users;

解锁：
ALTER USER scott ACCOUNT UNLOCK;

修改用户密码：
ALTER USER scott IDENTIFIED BY tiger;