VIEW: SYS.DBA_AQ_AGENT_PRIVS

Source

View Text - Preformatted

(SELECT u.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 FROM SYSTEM.AQ$_Internet_Agent_Privs t RIGHT OUTER JOIN  SYSTEM.AQ$_Internet_Agents u ON t.agent_name = u.agent_name)

View Text - HTML Formatted

(SELECT U.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
FROM SYSTEM.AQ$_INTERNET_AGENT_PRIVS T RIGHT OUTER JOIN SYSTEM.AQ$_INTERNET_AGENTS U ON T.AGENT_NAME = U.AGENT_NAME)