Ciberterminal Wiki

User Tools

Site Tools

Trace:
dba:oracle:oracle_sql_querys:users

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision		Previous revision
Next revisionBoth sides next revision
oracle:oracle_sql_querys:users [2018/10/10 08:30] – created dodgerdba:oracle:oracle_sql_querys:users [2022/02/11 11:12] – ↷ Page moved from oracle:oracle_sql_querys:users to dba:oracle:oracle_sql_querys:users dodger
Line 3: Line 3:
 =====Listar===== =====Listar=====
   * Todos:   * Todos:
-<code sql>SELECT USERNAME, PASSWORD, PROFILE from dba_users ;</code>+<code sql>SELECT USERNAME, PASSWORD, PROFILE, ACCOUNT_STATUS from dba_users order by 1 ;</code>
   * Activos:   * Activos:
 <code sql>SELECT USERNAME, PASSWORD, PROFILE, ACCOUNT_STATUS from dba_users WHERE ACCOUNT_STATUS LIKE 'OPEN';</code> <code sql>SELECT USERNAME, PASSWORD, PROFILE, ACCOUNT_STATUS from dba_users WHERE ACCOUNT_STATUS LIKE 'OPEN';</code>