VIEW: SYS.EXU9PGP

Source

View Text - Preformatted

SELECT  g.gname, u.name, o.name
        FROM    sys.rls_grp$ g, sys.user$ u, sys.obj$ o
        WHERE   g.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 G.GNAME
, U.NAME
, O.NAME
FROM SYS.RLS_GRP$ G
, SYS.USER$ U
, SYS.OBJ$ O
WHERE G.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'))