VIEW: SYS.EXPGETMAPOBJ

Source

View Text - Preformatted

SELECT  t.pctfree$, t.obj#
        FROM    sys.tab$ t, sys.obj$ o
        WHERE   t.obj# = o.obj#
        AND     (userenv('SCHEMAID') IN (o.owner#, 0) OR
                 EXISTS (
                    SELECT  role
                    FROM    sys.session_roles
                    WHERE   role = 'SELECT_CATALOG_ROLE'))

View Text - HTML Formatted

SELECT T.PCTFREE$
, T.OBJ#
FROM SYS.TAB$ T
, SYS.OBJ$ O
WHERE T.OBJ# = O.OBJ#
AND (USERENV('SCHEMAID') IN (O.OWNER#
, 0) OR EXISTS ( SELECT ROLE
FROM SYS.SESSION_ROLES
WHERE ROLE = 'SELECT_CATALOG_ROLE'))