SELECT "OBJID","GRANTOR","GRANTORID","GRANTEE","PRIV","WHO","WGO","CREATORID","SEQUENCE","ISDIR","TYPE"
FROM sys.exu8grn
WHERE grantorid = userenv('SCHEMAID') AND
creatorid = userenv('SCHEMAID')
SELECT "OBJID"
, "GRANTOR"
, "GRANTORID"
, "GRANTEE"
, "PRIV"
, "WHO"
, "WGO"
, "CREATORID"
, "SEQUENCE"
, "ISDIR"
, "TYPE"
FROM SYS.EXU8GRN
WHERE GRANTORID = USERENV('SCHEMAID') AND
CREATORID = USERENV('SCHEMAID')
|
|
|