oracle 查看 用户,用户权限,用户表空间,用户默认表空间.doc

oracle查看用户,用户权限,用户表空间,用户默认表空间查看用户和默认表空间的关系。selectusername,default_tablespacefromdba_users;::selecttable_namefromuser_tables;:selecttable_namefromall_tables;(其中包括系统表)selecttable_namefromall_tables;:select*fromtab/dba_tables/dba_objects/cat;下面介绍Oracle查询用户表空间◆Oracle查询用户表空间:select*fromuser_all_tables◆Oracle查询所有函数和储存过程:select*fromuser_source◆Oracle查询所有用户:select**fromdba_users◆Oracle查看当前用户连接:select*fromv$Session◆Oracle查看当前用户权限:select*fromsession_privs◆Oracle查看用户表空间使用情况:"FileNo","Tablespace_name","Bytes",-sum(nvl(,0))"Used",sum(nvl(,0))"Free",sum(nvl(,0))/*100"%free"fromdba_data_filesa,=(+),,;:select*fromdba_user;select*fromall_users;select*fromuser_users;:select*fromdba_sys_privs;select*fromall_sys_privs;select*fromuser_sys_privs;:select*fromdba_tab_privs;select*fromall_tab_privs;select*fromuser_tab_privs;:select*fromdba_roles;:select*fromdba_role_privs;select*fromuser_role_privs;:select*fromrole_sys_privs;select*fromrole_tab_privs;