Oracle的数据字典

describe dictionary

DBA_

ALL_

USER_

user_tables 查看表信息

user_objects 查看用户所有表信息

user_tab_columns 查看列信息

user_views 查看用户视图信息

user_sequences 查看用户序列值

user_indexes 查看用户索引

user_ind_columns 查看用户索引

dba_users

dba_indexes

SELECT * FROM ALL_TABLES;系统里有权限的表

SELECT * FROM DBA_TABLES; 系统表

SELECT * FROM USER_TABLES; 当前用户下的表

role_sys_privs

role_tab_privs

user_role_privs

user_sys_privs

user_tab_privs_made

user_tab_privs_recd

user_col_privs_made 

user_col_privs_recd

user_constraints 用户的约束

select constraint_name,constraint_type,search_condition

from user_constraints

where table_name = 'EMPLOYEES';

user_cons_columns 用户的约束关联

select constraint_name,column_name

from user_cons_columns

where table_name = 'EMPLOYEES';

1、查看所有用户

select * from dba_user;

select * from all_users;

select * from user_users;

2、查看用户系统权限

select * from dba_sys_privs;

select * from all_sys_privs;

select * from user_sys_privs;

3、查看用户对象权限

select * from dba_tab_privs;

select * from all_tab_privs;

select * from user_tab_privs;

4、查看所有角色

select * from dba_roles;

5、查看用户所拥有的角色

select * from dba_role_privs;

select * from user_role_privs;

6、查看当前用户的缺省表空间

select username,default_tablespace from user_users;

7、查看某个角色的具体权限

如grant connect,resource,create session,create view to TEST;

8、查看RESOURCE具有那些权限

用SELECT * FROM DBA_SYS_PRIVS WHERE GRANTEE='RESOURCE';

查看ASM信息

select * from dba_tablespaces;

select file_name,tablespace_name,bytes/1024/1024/1024g from dba_data_files;

select * from v$asm_diskgroup;

select * from v$asm_disk_stat;

select group_number,name,state,type,total_mb,free_mb from v$asm_diskgroup;

select name from v$datafile;

select group_number,header_status,state,path,udid from v$asm_disk_stat;