LISTING USER ON ORACLE DATABASE

Sometimes, we need to list user in our database. Below is command for listing user in Oracle Database

SQL> set lines 131
SQL> set pages 100   
SQL> alter session set nls_date_format='DD-MM-YYYY HH24:MI:SS';
Session altered.
SQL> select username,account_status,created,default_tablespace from dba_users;

USERNAME                      ACCOUNT_STATUS         CREATED            DEFAULT_TABLESPACE
------------------------------ --------------------------------  -------------------          ------------------------------
SYSTEM                                      OPEN                      01-10-2008 20:56:15       SYSTEM
SYS                                              OPEN                      01-10-2008 20:56:15       SYSTEM
OUTLN                                        LOCKED                01-10-2008 20:56:19       SYSTEM
DBSNMP                                     LOCKED                 01-10-2008 21:05:23       SYSAUX

4 rows selected.