VIEW: SYS.KU$_XSSECCLSH_VIEW

Source

View Text - Preformatted

select '1','0',
  h.sc#,
  h.parent_sc#,
  (select name  from xs$obj o where o.id=h.parent_sc#),
  (select owner from xs$obj o where o.id=h.parent_sc#)
  from xs$seccls_h h

View Text - HTML Formatted

SELECT '1'
, '0'
, H.SC#
, H.PARENT_SC#
, (SELECT NAME
FROM XS$OBJ O
WHERE O.ID=H.PARENT_SC#)
, (SELECT OWNER
FROM XS$OBJ O
WHERE O.ID=H.PARENT_SC#)
FROM XS$SECCLS_H H