oracle数据字典

显示初始化参数：show parameter;

查看数据库字典：select * from dict;

查询系统权限：select * from dba_sys_privs where grantee='SCOTT';  注意：必须大写

查询对象权限：select * from dba_tab_privs where grantee='SCOTT';

查询列权限：select * from dba_col_privs
查看角色权限：select * from dba_role_privs where grantee='SCOTT';

以上是以dba身份  可以换成user  或者all

查看角色拥有的权限：select * from role_sys_privs where role='CONNECT';

查看当前数据库全称：select * from global_name;

查询表空间：select * from dba_tabespaces;