select '1','0',
ap.sc#,
ap.aggr_priv#,
ap.implied_priv#,
(select name from xs$obj o where o.id = ap.implied_priv#),
(select owner from xs$obj o where o.id = ap.implied_priv#)
from xs$aggr_priv ap
View Text - HTML Formatted
SELECT '1' , '0' ,
AP.SC# ,
AP.AGGR_PRIV# ,
AP.IMPLIED_PRIV# ,
(SELECT NAME FROM XS$OBJ O WHERE O.ID = AP.IMPLIED_PRIV#) ,
(SELECT OWNER FROM XS$OBJ O WHERE O.ID = AP.IMPLIED_PRIV#)
FROM XS$AGGR_PRIV AP