USERS

• Liste des users non système

SET lines 600
col USERNAME format a30
col ACCOUNT_STATUS format a20
col DEFAULT_TABLESPACE format a20
col PROFILE format a20
col LAST_LOGIN format a20
SELECT USERNAME,CREATED,ACCOUNT_STATUS,DEFAULT_TABLESPACE,PROFILE,LAST_LOGIN 
FROM dba_users
WHERE default_tablespace NOT IN('SYSTEM','SYSAUX');

• Liste des objets d'un user particulier

SELECT DISTINCT owner, tablespace_name FROM dba_segments WHERE owner IN ('xxx');