VIEW: SYS.AQ$INTERNET_USERS

Source

View Text - Preformatted

(SELECT t.agent_name, t.db_username, decode(bitand(u.protocol, 1), 0, 'NO  ', 1, 'YES ') http_enabled, decode(bitand(u.protocol, 2), 0, 'NO  ', 2, 'YES ') smtp_enabled, decode(bitand(u.protocol, 4), 0, 'NO  ', 4, 'YES ') ftp_enabled FROM SYSTEM.AQ$_Internet_Agent_Privs t, SYSTEM.AQ$_Internet_Agents u WHERE t.agent_name = u.agent_name UNION (SELECT x.agent_name, NULL, decode(bitand(x.protocol, 1), 0, 'NO  ', 1, 'YES ') http_enabled, decode(bitand(x.protocol, 2), 0, 'NO  ', 2, 'YES ') smtp_enabled, decode(bitand(x.protocol, 4), 0, 'NO  ', 4, 'YES ') ftp_enabled FROM SYSTEM.AQ$_Internet_Agents x WHERE (x.agent_name NOT IN (SELECT y.agent_name FROM SYSTEM.AQ$_Internet_Agent_Privs y))))

View Text - HTML Formatted

(SELECT T.AGENT_NAME
, T.DB_USERNAME
, DECODE(BITAND(U.PROTOCOL
, 1)
, 0
, 'NO '
, 1
, 'YES ') HTTP_ENABLED
, DECODE(BITAND(U.PROTOCOL
, 2)
, 0
, 'NO '
, 2
, 'YES ') SMTP_ENABLED
, DECODE(BITAND(U.PROTOCOL
, 4)
, 0
, 'NO '
, 4
, 'YES ') FTP_ENABLED
FROM SYSTEM.AQ$_INTERNET_AGENT_PRIVS T
, SYSTEM.AQ$_INTERNET_AGENTS U
WHERE T.AGENT_NAME = U.AGENT_NAME UNION (SELECT X.AGENT_NAME
, NULL
, DECODE(BITAND(X.PROTOCOL
, 1)
, 0
, 'NO '
, 1
, 'YES ') HTTP_ENABLED
, DECODE(BITAND(X.PROTOCOL
, 2)
, 0
, 'NO '
, 2
, 'YES ') SMTP_ENABLED
, DECODE(BITAND(X.PROTOCOL
, 4)
, 0
, 'NO '
, 4
, 'YES ') FTP_ENABLED
FROM SYSTEM.AQ$_INTERNET_AGENTS X
WHERE (X.AGENT_NAME NOT IN (SELECT Y.AGENT_NAME
FROM SYSTEM.AQ$_INTERNET_AGENT_PRIVS Y))))