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

oracle 查看用户,用户权限,用户表空间,用户默认表空间 
 
 
。 
  
  select   username,default_tablespace   from   dba_users;
 
:
 
select  table_name from  user_tables; 
 
 
:
 
select table_name  from all_tables;  
 
(其中包括系统表)
 
select table_name  from all_tables;   
 
: 
 
select  *  from  tab/dba_tables/dba_objects/cat; 
 
下面介绍Oracle查询用户表空间
 
◆Oracle查询用户表空间:select * from user_all_tables
 
◆Oracle查询所有函数和储存过程:select * from user_source
 
◆Oracle查询所有用户:select * from * from dba_users
 
◆Oracle查看当前用户连接:select * from v$Session
 
◆Oracle查看当前用户权限:select * from session_privs
 
◆Oracle查看用户表空间使用情况:
 
"FileNo",  "Tablespace_name",   "Bytes",-
 
sum(nvl(,0)) "Used",  sum(nvl(,0)) "Free",  sum(nvl(,0))/*100 "%free"  
 
from dba_data_files a, dba_free_space b  where =(+)  group by ,  
 
, order by ; 
 
 
 
:
 
  select * from dba_user;
 
  select * from all_users;
 
  select * from user_users;
 
:
 
  select * from dba_sys_privs;
 
  select * from all_sys_privs;
 
  select * from user_sys_privs;
 
:
 
  select * from dba_tab_privs;
 
  select * from all_tab_privs;
 
  select * from user_tab_privs;
 
:
 
  select * from dba_roles;
 
:
 
  select * from dba_role_privs;
 
  select * from user_role_privs;
 
 
:
 
 
  select * from role_sys_privs;
 
 
  select * from role_tab_privs;
 
 

 
 
  select * from system_privilege_map; 
 
 

 
 
  select * from table_privilege_map;
 
 
以上是在Oracle中查看用户权限,
 
在DB2中为:
 
  select * from
 
  或者
 
  get authorizations
 
 
查看sid
 
  select * from v$instance
<!-- [if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:Punctua