VIEW: SYS.ALL_SQL_TRANSLATION_PROFILES

Source

View Text - Preformatted

select u.name, o.name,
       case when (s.txlrowner is null and s.txlrname is null) then
         null
       else
         '"'||s.txlrowner||'"."'||s.txlrname||'"'
       end,
       decode(bitand(s.flags, 1), 1, 'TRUE', 0, 'FALSE'),
       decode(bitand(s.flags, 2), 2, 'TRUE', 0, 'FALSE'),
       decode(bitand(s.flags, 4), 4, 'TRUE', 0, 'FALSE'),
       decode(bitand(s.flags, 8), 8, 'TRUE', 0, 'FALSE'),
       decode(bitand(s.flags, 16), 16, 'TRUE', 0, 'FALSE')
  from sys.sqltxl$ s, sys."_CURRENT_EDITION_OBJ" o, sys.user$ u
 where s.obj# = o.obj# and
       o.owner# = u.user# and
       (
         o.owner# = userenv('SCHEMAID')
         or
         exists (select null from sys.objauth$ oa
                  where oa.obj# = o.obj#
                    and oa.grantee# in (select kzsrorol from x$kzsro)
                    and oa.privilege# in (0 /* ALTER */, 29 /* USE */))
         or
         exists (select null from v$enabledprivs
                 where priv_number in (
                                -335 /* CREATE ANY SQL TRANSLATION PROFILE */,
                                -336 /* ALTER ANY SQL TRANSLATION PROFILE  */,
                                -337 /* USE ANY SQL TRANSLATION PROFILE    */,
                                -338 /* DROP ANY SQL TRANSLATION PROFILE   */
                                      )
                )
       )

View Text - HTML Formatted

SELECT U.NAME
, O.NAME
, CASE WHEN (S.TXLROWNER IS NULL
AND S.TXLRNAME IS NULL) THEN NULL ELSE '"'||S.TXLROWNER||'"."'||S.TXLRNAME||'"' END
, DECODE(BITAND(S.FLAGS
, 1)
, 1
, 'TRUE'
, 0
, 'FALSE')
, DECODE(BITAND(S.FLAGS
, 2)
, 2
, 'TRUE'
, 0
, 'FALSE')
, DECODE(BITAND(S.FLAGS
, 4)
, 4
, 'TRUE'
, 0
, 'FALSE')
, DECODE(BITAND(S.FLAGS
, 8)
, 8
, 'TRUE'
, 0
, 'FALSE')
, DECODE(BITAND(S.FLAGS
, 16)
, 16
, 'TRUE'
, 0
, 'FALSE')
FROM SYS.SQLTXL$ S
, SYS."_CURRENT_EDITION_OBJ" O
, SYS.USER$ U
WHERE S.OBJ# = O.OBJ# AND O.OWNER# = U.USER# AND ( O.OWNER# = USERENV('SCHEMAID') OR EXISTS (SELECT NULL
FROM SYS.OBJAUTH$ OA
WHERE OA.OBJ# = O.OBJ#
AND OA.GRANTEE# IN (SELECT KZSROROL
FROM X$KZSRO)
AND OA.PRIVILEGE# IN (0 /* ALTER */
, 29 /* USE */)) OR EXISTS (SELECT NULL
FROM V$ENABLEDPRIVS
WHERE PRIV_NUMBER IN ( -335 /* CREATE ANY SQL TRANSLATION PROFILE */
, -336 /* ALTER ANY SQL TRANSLATION PROFILE */
, -337 /* USE ANY SQL TRANSLATION PROFILE */
, -338 /* DROP ANY SQL TRANSLATION PROFILE */ ) ) )