VIEW: SYS.EXU8SPV

Source

View Text - Preformatted

SELECT  u1$.name, u1$.user#, m$.name, NVL(a$.option$, 0), a$.sequence#
        FROM    sys.sysauth$ a$, sys.system_privilege_map m$, sys.user$ u1$
        WHERE   a$.grantee# = u1$.user# AND
                a$.privilege# = m$.privilege AND
                BITAND(m$.property, 1) != 1 AND
                u1$.name NOT IN ('CONNECT', 'RESOURCE', 'DBA', '_NEXT_USER',
                                 'EXP_FULL_DATABASE', 'IMP_FULL_DATABASE',
                                 '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', 'ORDDATA',
                                 'GSMADMIN_INTERNAL', 'GSMUSER', 'GSMCATUSER',
                                 'LOGSTDBY_ADMINISTRATOR', 'DBHADOOP',
                                 'OLAPSYS', 'FLOWS_FILES', 'APEX_040200')

View Text - HTML Formatted

SELECT U1$.NAME
, U1$.USER#
, M$.NAME
, NVL(A$.OPTION$
, 0)
, A$.SEQUENCE#
FROM SYS.SYSAUTH$ A$
, SYS.SYSTEM_PRIVILEGE_MAP M$
, SYS.USER$ U1$
WHERE A$.GRANTEE# = U1$.USER# AND A$.PRIVILEGE# = M$.PRIVILEGE AND BITAND(M$.PROPERTY
, 1) != 1 AND U1$.NAME NOT IN ('CONNECT'
, 'RESOURCE'
, 'DBA'
, '_NEXT_USER'
, 'EXP_FULL_DATABASE'
, 'IMP_FULL_DATABASE'
, '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'
, 'ORDDATA'
, 'GSMADMIN_INTERNAL'
, 'GSMUSER'
, 'GSMCATUSER'
, 'LOGSTDBY_ADMINISTRATOR'
, 'DBHADOOP'
, 'OLAPSYS'
, 'FLOWS_FILES'
, 'APEX_040200')