VIEW: SYS.EXU7SPV

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 
	     u1$.name not in 
	     ('CONNECT', 'RESOURCE', 'DBA', 'PUBLIC', '_NEXT_USER', 
	     'EXP_FULL_DATABASE', 'IMP_FULL_DATABASE') AND
             m$.privilege not in (-177, -178, -180, -181, -182, -183, -184, 
                                  -186, -188, -189, -190, -191, -192) AND
             m$.privilege > -200

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 U1$.NAME NOT IN ('CONNECT'
, 'RESOURCE'
, 'DBA'
, 'PUBLIC'
, '_NEXT_USER'
, 'EXP_FULL_DATABASE'
, 'IMP_FULL_DATABASE') AND M$.PRIVILEGE NOT IN (-177
, -178
, -180
, -181
, -182
, -183
, -184
, -186
, -188
, -189
, -190
, -191
, -192) AND M$.PRIVILEGE > -200