VIEW: SYS.EXU10NTA

Source

View Text - Preformatted

SELECT  u$.name, up$.name, pd$.flags,
                DECODE(pd$.flags,
                       2, 'WITH NO ROLES',
                       4, 'WITH ROLE',
                       8, 'WITH ROLE ALL EXCEPT', ' '),
                DECODE(pd$.credential_type#,
                       5, 'AUTHENTICATION REQUIRED', ' ')
        FROM    sys.user$ u$, sys.user$ up$, sys.proxy_info$ pd$
        WHERE   pd$.client# = u$.user# AND
                pd$.proxy# = up$.user#

View Text - HTML Formatted

SELECT U$.NAME
, UP$.NAME
, PD$.FLAGS
, DECODE(PD$.FLAGS
, 2
, 'WITH NO ROLES'
, 4
, 'WITH ROLE'
, 8
, 'WITH ROLE ALL EXCEPT'
, ' ')
, DECODE(PD$.CREDENTIAL_TYPE#
, 5
, 'AUTHENTICATION REQUIRED'
, ' ')
FROM SYS.USER$ U$
, SYS.USER$ UP$
, SYS.PROXY_INFO$ PD$
WHERE PD$.CLIENT# = U$.USER# AND PD$.PROXY# = UP$.USER#