VIEW: SYS.DEFPROPAGATOR

Source

View Text - Preformatted

SELECT
       p.username,
       p.userid,
       DECODE(u.name, NULL, 'INVALID', 'VALID'),
       p.created
     FROM system.def$_propagator p, sys.user$ u
     WHERE p.userid = u.user# (+)

View Text - HTML Formatted

SELECT P.USERNAME
, P.USERID
, DECODE(U.NAME
, NULL
, 'INVALID'
, 'VALID')
, P.CREATED
FROM SYSTEM.DEF$_PROPAGATOR P
, SYS.USER$ U
WHERE P.USERID = U.USER# (+)