一、查看用户的表空间
表：dba_users
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 |
SQL> desc dba_users; Name Null? Type ----------------------------------------- -------- ---------------------------- USERNAME NOT NULL VARCHAR2(30) USER_ID NOT NULL NUMBER PASSWORD VARCHAR2(30) ACCOUNT_STATUS NOT NULL VARCHAR2(32) LOCK_DATE DATE EXPIRY_DATE DATE DEFAULT_TABLESPACE NOT NULL VARCHAR2(30) TEMPORARY_TABLESPACE NOT NULL VARCHAR2(30) CREATED NOT NULL DATE PROFILE NOT NULL VARCHAR2(30) INITIAL_RSRC_CONSUMER_GROUP VARCHAR2(30) EXTERNAL_NAME VARCHAR2(4000) PASSWORD_VERSIONS VARCHAR2(8) EDITIONS_ENABLED VARCHAR2(1) AUTHENTICATION_TYPE VARCHAR2(8) SQL> select username,default_tablespace from dba_users; USERNAME DEFAULT_TABLESPACE ------------------------------ ------------------------------ PATROL TBS_MONITOR |
二、查看表空间
表：dba_data_files
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 |
SQL> desc dba_data_files Name Null? Type ----------------------------------------- -------- ---------------------------- FILE_NAME VARCHAR2(513) FILE_ID NUMBER TABLESPACE_NAME VARCHAR2(30) BYTES NUMBER BLOCKS NUMBER STATUS VARCHAR2(9) RELATIVE_FNO NUMBER AUTOEXTENSIBLE VARCHAR2(3) MAXBYTES NUMBER MAXBLOCKS NUMBER INCREMENT_BY NUMBER USER_BYTES NUMBER USER_BLOCKS NUMBER ONLINE_STATUS VARCHAR2(7) SQL> select file_name,tablespace_name,bytes,maxbytes from dba_data_files where tablespace_name='TBS_MONITOR'; FILE_NAME -------------------------------------------------------------------------------- TABLESPACE_NAME BYTES MAXBYTES ------------------------------ ---------- ---------- +DGDATA/bj4adb/datafile/tbs_cipa TBS_MONITOR 1073741824 1.0737E+10 |
三、查看用户权限（注意用户名大写，否则查不到）
表：dba_sys_privs
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 |
SQL> DESC DBA_SYS_PRIVS; Name Null? Type ----------------------------------------- -------- ---------------------------- GRANTEE NOT NULL VARCHAR2(30) PRIVILEGE NOT NULL VARCHAR2(40) ADMIN_OPTION VARCHAR2(3) SQL> select * from dba_sys_privs where grantee='PATROL'; GRANTEE PRIVILEGE ADM ------------------------------ ---------------------------------------- --- PATROL UNLIMITED TABLESPACE NO PATROL CREATE TABLESPACE NO PATROL CREATE VIEW NO PATROL CREATE TABLE NO PATROL CREATE SESSION NO |
四、查看用户角色（注意用户名大写，否则查不到）
表：dba_role_privs
|
1 2 3 4 5 6 7 8 9 10 11 12 13 |
SQL> DESC DBA_ROLE_PRIVS; Name Null? Type ----------------------------------------- -------- ---------------------------- GRANTEE VARCHAR2(30) GRANTED_ROLE NOT NULL VARCHAR2(30) ADMIN_OPTION VARCHAR2(3) DEFAULT_ROLE VARCHAR2(3) SQL> select * from dba_role_privs where grantee='PATROL'; GRANTEE GRANTED_ROLE ADM DEF ------------------------------ ------------------------------ --- --- PATROL DBA NO YES |