【原】视图学习

作者：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;