SELECT c$.obj#, ur$.name, c$.grantor#, ue$.name, o$.owner#, cl$.name,
m$.name, c$.sequence#, MOD(NVL(c$.option$, 0), 2)
FROM sys.objauth$ c$, sys.obj$ o$, sys.user$ ur$, sys.user$ ue$,
sys.table_privilege_map m$, sys.col$ cl$
WHERE c$.grantor# = ur$.user# AND
c$.grantee# = ue$.user# AND
c$.obj# = o$.obj# AND
c$.privilege# = m$.privilege AND
c$.obj# = cl$.obj# AND
c$.col# = cl$.col#
SELECT C$.OBJ#
, UR$.NAME
, C$.GRANTOR#
, UE$.NAME
, O$.OWNER#
, CL$.NAME
,
M$.NAME
, C$.SEQUENCE#
, MOD(NVL(C$.OPTION$
, 0)
, 2)
FROM SYS.OBJAUTH$ C$
, SYS.OBJ$ O$
, SYS.USER$ UR$
, SYS.USER$ UE$
,
SYS.TABLE_PRIVILEGE_MAP M$
, SYS.COL$ CL$
WHERE C$.GRANTOR# = UR$.USER# AND
C$.GRANTEE# = UE$.USER# AND
C$.OBJ# = O$.OBJ# AND
C$.PRIVILEGE# = M$.PRIVILEGE AND
C$.OBJ# = CL$.OBJ# AND
C$.COL# = CL$.COL#
|
|
|