VIEW: SYS.EXU8RLG

Source

View Text - Preformatted

SELECT  u1$.name, u1$.user#, u2$.name, u2$.user#, NVL(g$.option$, 0),
                g$.sequence#
        FROM    sys.user$ u1$, sys.user$ u2$, sys.sysauth$ g$
        WHERE   u1$.user# = g$.grantee# AND
                u2$.user# = g$.privilege# AND
                g$.privilege# > 0 AND
                u1$.name NOT IN ('ORDSYS',  'MDSYS', 'CTXSYS', 'ORDPLUGINS',
                                'LBACSYS', 'XDB',   'SI_INFORMTN_SCHEMA',
                                'DIP',  'DBSNMP', 'EXFSYS', 'WMSYS',
                                'ORACLE_OCM', 'ANONYMOUS', 'XS$NULL',
                                'APPQOSSYS', 'OJVMSYS', 'SYSBACKUP', 'SYSDG',
                                'SYSKM', 'DVSYS', 'DVF', 'DBHADOOP', 'ORDDATA',
                                'GSMADMIN_INTERNAL', 'GSMUSER', 'GSMCATUSER',
                                'LOGSTDBY_ADMINISTRATOR', 'OLAPSYS',
                                'FLOWS_FILES','APEX_040200')

View Text - HTML Formatted

SELECT U1$.NAME
, U1$.USER#
, U2$.NAME
, U2$.USER#
, NVL(G$.OPTION$
, 0)
, G$.SEQUENCE#
FROM SYS.USER$ U1$
, SYS.USER$ U2$
, SYS.SYSAUTH$ G$
WHERE U1$.USER# = G$.GRANTEE# AND U2$.USER# = G$.PRIVILEGE# AND G$.PRIVILEGE# > 0 AND U1$.NAME NOT IN ('ORDSYS'
, 'MDSYS'
, 'CTXSYS'
, 'ORDPLUGINS'
, 'LBACSYS'
, 'XDB'
, 'SI_INFORMTN_SCHEMA'
, 'DIP'
, 'DBSNMP'
, 'EXFSYS'
, 'WMSYS'
, 'ORACLE_OCM'
, 'ANONYMOUS'
, 'XS$NULL'
, 'APPQOSSYS'
, 'OJVMSYS'
, 'SYSBACKUP'
, 'SYSDG'
, 'SYSKM'
, 'DVSYS'
, 'DVF'
, 'DBHADOOP'
, 'ORDDATA'
, 'GSMADMIN_INTERNAL'
, 'GSMUSER'
, 'GSMCATUSER'
, 'LOGSTDBY_ADMINISTRATOR'
, 'OLAPSYS'
, 'FLOWS_FILES'
, 'APEX_040200')