作者：david_zhang@sh 【转载时请以超链接形式标明文章】
链接：http://www.cnblogs.com/david-zhang-index/archive/2012/03/21/2409353.html
| 1.查询数据库中所用用户信息：select * from dba_users; | 2.查询数据库中所用用户信息：select * from all_users； |
| 3.查询当前账户信息：select * from user_users; | 4.查询数据库中所用表信息：select * from dba_tables; |
| 5.查询数据库中所用表信息：select * from all_tables; | 6.查询当前账户的表信息：select * from user_tables; |
| 7.查询数据库中所用对象：select * from dba_objects; | 8.查询数据库中所用对象：select * from all_objects; |
| 9.查询当前账户对象信息：select * from user_objects; | 10.查询某个用户所拥有的系统权限：select * from dba_sys_privs; |
| 11.当前用户所拥有的系统权限：select * from user_sys_privs; | 12.当前用户所拥有的全部权限:select * from session_privs; |
| 13.某个角色所拥有的系统权限:select * from role_sys_privs; | 14.当前角色被赋予的角色:select * from role_role_privs; |
| 15.某个角色被授予的系统权限:select * from dba_role_privs; | 16.当前用户被激活的角色:select * from session_roles; |
| 17.当前用户被授予的角色:select * from user_role_privs; | 18.查询某用户对某对象的权限:select * from dba_tab_privs; |
| 19.查询某用户对某对象的权限:select * from all_tab_privs; | 20.查询当前用户对某对象的权限:select * from user_tab_privs; |
| 21.查询所有角色：select * from dba_roles; | 22.某角色对某对象的权限：select * from role_tab_privs; |
| 23.数据库所有表空间信息：select * from dba_tablespaces; | 24.当前用户表空间信息：select * from user_tablespaces; |
| 25.查询所用数据文件信息：select * from dba_data_files; | 26.显示控制文件中数据文件信息：select * form v$datafile; |