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
Last 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:36] – external edit 127.0.0.1
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>
Line 249: Line 249:
 -- Andy Barry/A -- Andy Barry/A
 -- 20/02/06 -- 20/02/06
--- modified by jholgado+-- modified by dodger
 -- 17/02/2010 -- 17/02/2010