3、查看當(dāng)前用戶權(quán)限：
select * from session_privs;
4、查看所有用戶系統(tǒng)權(quán)限
select * from dba_sys_privs;
select * from user_sys_privs;
5、查看所有用戶對(duì)象權(quán)限
select * from dab_tab_privs;
select * from all_tab_privs;
select * from user_tab_privs;
6、查看所有角色
select * from dba_roles;
select * from dba_role_privs;
select * from user_role_privs;
7、查看所有表空間、臨時(shí)表空間等信息
select tablespace_name,file_name,bytes file_size,autoextensible from dba_data_files;
select tablespace_name,file_name,bytes file_size,autoextensible from dba_temp_files;
8、查看用戶表空間使用情況：
select
a.file_id "FileNo",a.tablespace_name "Tablespace_name",
a.bytes "Bytes",a.bytes-sum(nvl(b.bytes,0)) "Used", sum(nvl(b.bytes,0)) "Free",sum(nvl(b.bytes,0))/a.bytes*100 "%free"
from dba_data_files a,dba_free_space b
where a.file_id=b.file_id(+)
group by a.tablespace_name , a.file_id,a.bytes
order by a.tablespace_name;
9、查看用戶所有對(duì)象
select table_name,num_rows from user_tables;
select * from all_tables;
10、詢所有函數(shù)和存儲(chǔ)過程
select * from dba_source;
select * from user_source;