DBA Data[Home] [Help]

VIEW: SYS.KU$_XSAGGPRIV_VIEW

Source

View Text - Preformatted

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