1、显示用户信息
（1）显示当前会话用户
10:16:18 SQL> show user;
USER is "SYS"
（2）显示特权用户
10:17:07 SQL> conn sys/oracle as sysdba;
Connected.
10:17:09 SQL> select * from v$pwfile_users;
USERNAME SYSDB SYSOP
------------------------------ ----- -----
SYS TRUE TRUE
（3)显示用户信息
10:17:22 SQL> col username format a20
10:18:32 SQL> col default_tablespace for a20
10:18:45 SQL> col temporary_tablespace for a20
10:18:59 SQL> select username,default_tablespace ,temporary_tablespace
10:19:22 2 from dba_users;
USERNAME DEFAULT_TABLESPACE TEMPORARY_TABLESPACE
-------------------- -------------------- --------------------
OPS$ORACLE USERS TEMP
SCOTT USERS TEMGRP01
HR USERS TEMGRP01
TEST USERS TEMGRP01
TSMSYS USERS TEMGRP01
BI USERS TEMGRP01
PM USERS TEMGRP01
MDDATA USERS TEMGRP01
IX USERS TEMGRP01
SH USERS TEMGRP01
DIP USERS TEMGRP01
OE USERS TEMGRP01
DBSNMP SYSAUX TEMGRP01
SYSMAN SYSAUX TEMGRP01
MDSYS SYSAUX TEMGRP01
ORDSYS SYSAUX TEMGRP01
EXFSYS SYSAUX TEMGRP01
USERNAME DEFAULT_TABLESPACE TEMPORARY_TABLESPACE
-------------------- -------------------- --------------------
DMSYS SYSAUX TEMGRP01
WMSYS SYSAUX TEMGRP01
CTXSYS SYSAUX TEMGRP01
ANONYMOUS SYSAUX TEMGRP01
XDB SYSAUX TEMGRP01
ORDPLUGINS SYSAUX TEMGRP01
SI_INFORMTN_SCHEMA SYSAUX TEMGRP01
OLAPSYS SYSAUX TEMGRP01
MGMT_VIEW SYSTEM TEMGRP01
SYS SYSTEM TEMGRP01
SYSTEM SYSTEM TEMGRP01
查看本栏目更多精彩内容：http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/