VIEW: SYS.EXU9PCT

Source

View Text - Preformatted

SELECT  c.ns, c.attr, u.name, o.name
        FROM    sys.rls_ctx$ c, sys.user$ u, sys.obj$ o
        WHERE   c.obj# = o.obj# AND
                u.user# = o.owner# 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 C.NS
, C.ATTR
, U.NAME
, O.NAME
FROM SYS.RLS_CTX$ C
, SYS.USER$ U
, SYS.OBJ$ O
WHERE C.OBJ# = O.OBJ# AND U.USER# = O.OWNER# AND (USERENV('SCHEMAID') IN (O.OWNER#
, 0) OR EXISTS ( SELECT ROLE
FROM SYS.SESSION_ROLES
WHERE ROLE = 'SELECT_CATALOG_ROLE'))