[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#