VIEW: SYS.EXU9NOS

Source

View Text - Preformatted

SELECT  to$.obj#, to$.owner#
        FROM    sys.obj$ to$, sys.obj$ io$, sys.ind$ ind$
        WHERE   ind$.bo# = to$.obj# AND
                ind$.obj# = io$.obj# AND
                ind$.blevel != -1 AND
                ind$.type# = 8 AND                              /* LOB index */
                (userenv('SCHEMAID') IN (to$.owner#, 0) OR
                 EXISTS (
                    SELECT  role
                    FROM    sys.session_roles
                    WHERE   role = 'SELECT_CATALOG_ROLE'))
      UNION ALL                            /* Table cannot have associations */
        SELECT  to$.obj#, to$.owner#
        FROM    sys.obj$ to$, sys.association$ a$
        WHERE   to$.obj# = a$.obj# AND
                to$.type# = 2 AND                                   /* Table */
                (userenv('SCHEMAID') IN (to$.owner#, 0) OR
                 EXISTS (
                    SELECT  role
                    FROM    sys.session_roles
                    WHERE   role = 'SELECT_CATALOG_ROLE'))
      UNION ALL               /* Type used in table cannot have associations */
        SELECT  to$.obj#, to$.owner#
        FROM    sys.obj$ to$, sys.obj$ tt$, sys.coltype$ ct$,
                sys.association$ a$
        WHERE   to$.obj# = ct$.obj# AND
                ct$.toid = tt$.oid$ AND
                tt$.obj# = a$.obj# AND
                (userenv('SCHEMAID') IN (to$.owner#, 0) OR
                 EXISTS (
                    SELECT  role
                    FROM    sys.session_roles
                    WHERE   role = 'SELECT_CATALOG_ROLE'))

View Text - HTML Formatted

SELECT TO$.OBJ#
, TO$.OWNER#
FROM SYS.OBJ$ TO$
, SYS.OBJ$ IO$
, SYS.IND$ IND$
WHERE IND$.BO# = TO$.OBJ# AND IND$.OBJ# = IO$.OBJ# AND IND$.BLEVEL != -1 AND IND$.TYPE# = 8
AND /* LOB INDEX */ (USERENV('SCHEMAID') IN (TO$.OWNER#
, 0) OR EXISTS ( SELECT ROLE
FROM SYS.SESSION_ROLES
WHERE ROLE = 'SELECT_CATALOG_ROLE')) UNION ALL /* TABLE CANNOT HAVE ASSOCIATIONS */ SELECT TO$.OBJ#
, TO$.OWNER#
FROM SYS.OBJ$ TO$
, SYS.ASSOCIATION$ A$
WHERE TO$.OBJ# = A$.OBJ# AND TO$.TYPE# = 2
AND /* TABLE */ (USERENV('SCHEMAID') IN (TO$.OWNER#
, 0) OR EXISTS ( SELECT ROLE
FROM SYS.SESSION_ROLES
WHERE ROLE = 'SELECT_CATALOG_ROLE')) UNION ALL /* TYPE USED IN TABLE CANNOT HAVE ASSOCIATIONS */ SELECT TO$.OBJ#
, TO$.OWNER#
FROM SYS.OBJ$ TO$
, SYS.OBJ$ TT$
, SYS.COLTYPE$ CT$
, SYS.ASSOCIATION$ A$
WHERE TO$.OBJ# = CT$.OBJ# AND CT$.TOID = TT$.OID$ AND TT$.OBJ# = A$.OBJ# AND (USERENV('SCHEMAID') IN (TO$.OWNER#
, 0) OR EXISTS ( SELECT ROLE
FROM SYS.SESSION_ROLES
WHERE ROLE = 'SELECT_CATALOG_ROLE'))