DBA Data[Home] [Help]

VIEW: SYS.TRUSTED_SERVERS

Source

View Text - Preformatted

select a.trust, b.dbname from sys.trusted_list$ b,
(select decode (dbname, '+*','Untrusted', '-*', 'Trusted') trust
from sys.trusted_list$ where dbname like '%*') a
where b.dbname not like '%*'
union
select decode (dbname, '-*', 'Untrusted', '+*', 'Trusted') trust, 'All'
from sys.trusted_list$
where dbname like '%*'
View Text - HTML Formatted

SELECT A.TRUST
, B.DBNAME
FROM SYS.TRUSTED_LIST$ B
, (SELECT DECODE (DBNAME
, '+*'
, 'UNTRUSTED'
, '-*'
, 'TRUSTED') TRUST FROM SYS.TRUSTED_LIST$
WHERE DBNAME LIKE '%*') A WHERE B.DBNAME NOT LIKE '%*' UNION SELECT DECODE (DBNAME
, '-*'
, 'UNTRUSTED'
, '+*'
, 'TRUSTED') TRUST
, 'ALL' FROM SYS.TRUSTED_LIST$ WHERE DBNAME LIKE '%*'