VIEW: SYS.KU$_TAB_SUBNAME_VIEW

Source

View Text - Preformatted

SELECT sov.owner_name, sov.name, sov.subname, NULL, ts$.name
  FROM   sys.ku$_schemaobj_view sov, tabpart$ tp, ts$
  WHERE  sov.obj_num=tp.obj# AND
         tp.ts# = ts$.ts# AND
         (SYS_CONTEXT('USERENV','CURRENT_USERID') IN (sov.owner_num, 0) OR
          EXISTS ( SELECT * FROM sys.session_roles
                   WHERE role='SELECT_CATALOG_ROLE' ))
UNION ALL
  SELECT sov.owner_name, sov.name, bo.subname, sov.subname, ts$.name
  FROM   sys.ku$_schemaobj_view sov, sys.obj$ bo, tabsubpart$ tsp,
         tabcompart$ tcp, ts$
  WHERE  tsp.obj# = sov.obj_num AND
         tcp.obj# = tsp.pobj# AND
         tcp.obj# = bo.obj# AND
         tsp.ts# = ts$.ts# AND
         (SYS_CONTEXT('USERENV','CURRENT_USERID') IN (sov.owner_num, 0) OR
          EXISTS ( SELECT * FROM sys.session_roles
                   WHERE role='SELECT_CATALOG_ROLE' ))
UNION ALL
  SELECT sov.owner_name, sov.name, sov.subname, NULL, ts$.name
  FROM   sys.ku$_schemaobj_view sov, indpart$ ip, ind$ i, ts$
  WHERE  ip.obj# = sov.obj_num AND
         ip.bo# = i.obj# AND
         i.type# = 4 AND
         ip.ts# = ts$.ts# AND
         (SYS_CONTEXT('USERENV','CURRENT_USERID') IN (sov.owner_num, 0) OR
          EXISTS ( SELECT * FROM sys.session_roles
                   WHERE role='SELECT_CATALOG_ROLE' ))

View Text - HTML Formatted

SELECT SOV.OWNER_NAME
, SOV.NAME
, SOV.SUBNAME
, NULL
, TS$.NAME
FROM SYS.KU$_SCHEMAOBJ_VIEW SOV
, TABPART$ TP
, TS$
WHERE SOV.OBJ_NUM=TP.OBJ# AND TP.TS# = TS$.TS# AND (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') IN (SOV.OWNER_NUM
, 0) OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' )) UNION ALL SELECT SOV.OWNER_NAME
, SOV.NAME
, BO.SUBNAME
, SOV.SUBNAME
, TS$.NAME
FROM SYS.KU$_SCHEMAOBJ_VIEW SOV
, SYS.OBJ$ BO
, TABSUBPART$ TSP
, TABCOMPART$ TCP
, TS$
WHERE TSP.OBJ# = SOV.OBJ_NUM AND TCP.OBJ# = TSP.POBJ# AND TCP.OBJ# = BO.OBJ# AND TSP.TS# = TS$.TS# AND (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') IN (SOV.OWNER_NUM
, 0) OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' )) UNION ALL SELECT SOV.OWNER_NAME
, SOV.NAME
, SOV.SUBNAME
, NULL
, TS$.NAME
FROM SYS.KU$_SCHEMAOBJ_VIEW SOV
, INDPART$ IP
, IND$ I
, TS$
WHERE IP.OBJ# = SOV.OBJ_NUM AND IP.BO# = I.OBJ# AND I.TYPE# = 4 AND IP.TS# = TS$.TS# AND (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') IN (SOV.OWNER_NUM
, 0) OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))