查看所有用户
select * from all_users;
select * from dba_users;
select * from user_users;查看SID
select * from v$instance;查看所有表空间
select * from v$tablespace;查询表空间文件所在路径
select * from dba_data_files;查看用户所拥有的角色
select * from dba_role_privs;
select * from user_role_privs;
用户修改密码，Oracle给用户解锁
ALTER USER "SCOTT" IDENTIFIED BY "*******"
ALTER USER "SCOTT" ACCOUNT UNLOCK
显示当前连接用户
show user;原创文章，作者：Maggie-Hunter，如若转载，请注明出处：https://blog.ytso.com/tech/database/4135.html