4e7683aee2
Grosse mise à jour : - style moderne des tableaux et code - code structuré et factorisé - sql et sh affinés
19 lines
368 B
SQL
19 lines
368 B
SQL
prompt <h2>DBA Users </h2>
|
|
|
|
ALTER SESSION SET NLS_DATE_FORMAT ='YYYY/MM/DD HH24:MI';
|
|
|
|
select /* db-html-report */
|
|
X.USERNAME,
|
|
X.USER_ID,
|
|
X.ACCOUNT_STATUS,
|
|
X.LOCK_DATE,
|
|
X.EXPIRY_DATE,
|
|
X.DEFAULT_TABLESPACE,
|
|
X.TEMPORARY_TABLESPACE,
|
|
X.CREATED,
|
|
X.PROFILE,
|
|
X.PASSWORD_VERSIONS
|
|
FROM
|
|
DBA_USERS X
|
|
ORDER BY
|
|
X.USERNAME; |