VIEW: SYS.EXU9NTA

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#,
                       1, 'AUTHENTICATED USING CERTIFICATE',
                       2, 'AUTHENTICATED USING DISTINGUISHED NAME',
                       3, 'AUTHENTICATED USING KERBEROS',
                       4, 'AUTHENTICATED USING PASSWORD', ' '),
                DECODE(pd$.credential_version#,
                       1, DECODE(pd$.credential_type#,
                                 1, 'TYPE ''X.509''',
                                 3, 'VERSION ''1.0''', ' '), ' '),
                DECODE(pd$.credential_minor#,
                       1, DECODE(pd$.credential_type#,
                                 1, 'VERSION ''3''', ' '), ' ')
        FROM    sys.user$ u$, sys.user$ up$, sys.proxy_data$ 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#
, 1
, 'AUTHENTICATED USING CERTIFICATE'
, 2
, 'AUTHENTICATED USING DISTINGUISHED NAME'
, 3
, 'AUTHENTICATED USING KERBEROS'
, 4
, 'AUTHENTICATED USING PASSWORD'
, ' ')
, DECODE(PD$.CREDENTIAL_VERSION#
, 1
, DECODE(PD$.CREDENTIAL_TYPE#
, 1
, 'TYPE ''X.509'''
, 3
, 'VERSION ''1.0'''
, ' ')
, ' ')
, DECODE(PD$.CREDENTIAL_MINOR#
, 1
, DECODE(PD$.CREDENTIAL_TYPE#
, 1
, 'VERSION ''3'''
, ' ')
, ' ')
FROM SYS.USER$ U$
, SYS.USER$ UP$
, SYS.PROXY_DATA$ PD$
WHERE PD$.CLIENT# = U$.USER# AND PD$.PROXY# = UP$.USER#