VIEW: SYS.KU$_TRLINK_VIEW

Source

View Text - Preformatted

select '1','0',
         tl.dbname,
         decode(tl.dbname, '+*', 'DBMS_DISTRIBUTED_TRUST_ADMIN.ALLOW_ALL',
                           '-*', 'DBMS_DISTRIBUTED_TRUST_ADMIN.DENY_ALL',
                fdef.function),
         decode(tl.dbname, '+*', 0, '-*', 0, 1)
  from   sys.trusted_list$ tl,
         ( select  decode (dbname,
                           '+*', 'DBMS_DISTRIBUTED_TRUST_ADMIN.DENY_SERVER',
                           '-*', 'DBMS_DISTRIBUTED_TRUST_ADMIN.ALLOW_SERVER')
                           function
           from    sys.trusted_list$
           where   dbname like '%*') fdef
  where (SYS_CONTEXT('USERENV','CURRENT_USERID') = 0
        OR EXISTS ( SELECT * FROM sys.session_roles
                       WHERE role='SELECT_CATALOG_ROLE' ))

View Text - HTML Formatted

SELECT '1'
, '0'
, TL.DBNAME
, DECODE(TL.DBNAME
, '+*'
, 'DBMS_DISTRIBUTED_TRUST_ADMIN.ALLOW_ALL'
, '-*'
, 'DBMS_DISTRIBUTED_TRUST_ADMIN.DENY_ALL'
, FDEF.FUNCTION)
, DECODE(TL.DBNAME
, '+*'
, 0
, '-*'
, 0
, 1)
FROM SYS.TRUSTED_LIST$ TL
, ( SELECT DECODE (DBNAME
, '+*'
, 'DBMS_DISTRIBUTED_TRUST_ADMIN.DENY_SERVER'
, '-*'
, 'DBMS_DISTRIBUTED_TRUST_ADMIN.ALLOW_SERVER') FUNCTION
FROM SYS.TRUSTED_LIST$
WHERE DBNAME LIKE '%*') FDEF
WHERE (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') = 0 OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))