DBA Data[Home] [Help]

VIEW: SYS.KU$_PSW_HIST_LIST_VIEW

Source

View Text - Preformatted

select  h.user#,
          u.name,
          h.password,
          to_char(h.password_date,'YYYY/MM/DD HH24:MI:SS')
  from    sys.user_history$ h, sys.user$ u
  where   h.user# = u.user#
View Text - HTML Formatted

SELECT H.USER#
, U.NAME
, H.PASSWORD
, TO_CHAR(H.PASSWORD_DATE
, 'YYYY/MM/DD HH24:MI:SS')
FROM SYS.USER_HISTORY$ H
, SYS.USER$ U
WHERE H.USER# = U.USER#