select '1','0',
r.grantee#,
(select name from xs$obj o where o.id=r.grantee#),
r.role#,
(select name from xs$obj o where o.id=r.role#),
r.granter#,
(select name from xs$obj o where o.id=r.granter#),
r.start_date,
r.end_date
from xs$role_grant r, xs$obj xo
where xo.id = r.grantee#
and bitand(xo.flags,1) = 0 /* not Oracle supplied */
SELECT '1'
, '0'
,
R.GRANTEE#
,
(SELECT NAME
FROM XS$OBJ O
WHERE O.ID=R.GRANTEE#)
,
R.ROLE#
,
(SELECT NAME
FROM XS$OBJ O
WHERE O.ID=R.ROLE#)
,
R.GRANTER#
,
(SELECT NAME
FROM XS$OBJ O
WHERE O.ID=R.GRANTER#)
,
R.START_DATE
,
R.END_DATE
FROM XS$ROLE_GRANT R
, XS$OBJ XO
WHERE XO.ID = R.GRANTEE#
AND BITAND(XO.FLAGS
, 1) = 0 /* NOT ORACLE SUPPLIED */
|
|
|