VIEW: SYS.USER_AQ_AGENT_PRIVS

Source

View Text - Preformatted

SELECT u.agent_name, 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, SYSTEM.AQ$_Internet_Agents u, sys.user$ usr where u.agent_name = t.agent_name and usr.user# = USERENV('SCHEMAID') and usr.name = t.db_username

View Text - HTML Formatted

SELECT U.AGENT_NAME
, 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
, SYSTEM.AQ$_INTERNET_AGENTS U
, SYS.USER$ USR
WHERE U.AGENT_NAME = T.AGENT_NAME
AND USR.USER# = USERENV('SCHEMAID')
AND USR.NAME = T.DB_USERNAME