1、查看所有用户
select * from all_users;
select * from dba_users;
select * from user_users;
2、查看SID
select * from v$tablespace;
3、查看所有的表空间
select * from v$tablespace;
4、查看用户所拥有的角色
select * from dba_role_privs;
select * from user_role_privs;
5、用户修改密码,Oracle给用户解锁
ALTER USER "SCOTT" IDENTIFIED BY "*******"
ALTER USER "SCOTT" ACCOUNT UNLOCK