[Home] [Help]
SELECT t$.obj#, ur$.name, t$.grantor#, ue$.name, m$.name,
MOD(NVL(t$.option$/2, 0), 2), MOD(NVL(t$.option$, 0), 2),
o$.owner#, t$.sequence#,
DECODE ((o$.type#), 23, 1, 0), o$.type#
FROM sys.objauth$ t$, sys.obj$ o$, sys.user$ ur$,
sys.table_privilege_map m$, sys.user$ ue$
WHERE o$.obj# = t$.obj# AND
t$.privilege# = m$.privilege AND
t$.col# IS NULL AND
t$.grantor# = ur$.user# AND
t$.grantee# = ue$.user# AND
ue$.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', 'ORDDATA',
'GSMADMIN_INTERNAL', 'GSMUSER', 'GSMCATUSER',
'LOGSTDBY_ADMINISTRATOR', 'DBHADOOP',
'OLAPSYS', 'FLOWS_FILES', 'APEX_040200')
SELECT T$.OBJ#
, UR$.NAME
, T$.GRANTOR#
, UE$.NAME
, M$.NAME
,
MOD(NVL(T$.OPTION$/2
, 0)
, 2)
, MOD(NVL(T$.OPTION$
, 0)
, 2)
,
O$.OWNER#
, T$.SEQUENCE#
,
DECODE ((O$.TYPE#)
, 23
, 1
, 0)
, O$.TYPE#
FROM SYS.OBJAUTH$ T$
, SYS.OBJ$ O$
, SYS.USER$ UR$
,
SYS.TABLE_PRIVILEGE_MAP M$
, SYS.USER$ UE$
WHERE O$.OBJ# = T$.OBJ# AND
T$.PRIVILEGE# = M$.PRIVILEGE AND
T$.COL# IS NULL AND
T$.GRANTOR# = UR$.USER# AND
T$.GRANTEE# = UE$.USER# AND
UE$.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'
, 'ORDDATA'
,
'GSMADMIN_INTERNAL'
, 'GSMUSER'
, 'GSMCATUSER'
,
'LOGSTDBY_ADMINISTRATOR'
, 'DBHADOOP'
,
'OLAPSYS'
, 'FLOWS_FILES'
, 'APEX_040200')
|
|
|
|