VIEW: SYS.EXPGETENCCOLNAM

Source

View Text - Preformatted

SELECT c.name, c.obj#
        FROM   sys.col$ c, sys.obj$ o
        WHERE  bitand(c.property,67108864) = 67108864 AND /* encrypted column */
               c.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 C.NAME
, C.OBJ#
FROM SYS.COL$ C
, SYS.OBJ$ O
WHERE BITAND(C.PROPERTY
, 67108864) = 67108864
AND /* ENCRYPTED COLUMN */ C.OBJ# = O.OBJ# AND (USERENV('SCHEMAID') IN (O.OWNER#
, 0) OR EXISTS ( SELECT ROLE
FROM SYS.SESSION_ROLES
WHERE ROLE = 'SELECT_CATALOG_ROLE'))