Oracle Admin User (iii) How to display user information in Oracle

1. Display user Information

(1) Display the current session user

10:16:18 sql> Show user;

USER is "SYS"

(2) Show privileged users

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) Display user information

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

See more highlights of this column: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/