DBA_AQ_AGENT_PRIVS

DBA_AQ_AGENT_PRIVS displays information about the registered AQ agents that are mapped to all users in the database.

Related View

USER_AQ_AGENT_PRIVS displays information about the registered AQ agents that are mapped to the current user. This view does not display the DB_USERNAME column.

Column	Datatype	NULL	Description
`AGENT_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the AQ agent
`DB_USERNAME`	`VARCHAR2(30)`		Name of the database user that the agent maps to
`HTTP_ENABLED`	`VARCHAR2(4)`		Indicates whether the agent is allowed to access AQ through HTTP (`YES`) or not (`NO`)
`SMTP_ENABLED`	`VARCHAR2(4)`		Indicates whether the agent is allowed to access AQ through SMTP (`YES`) or not (`NO`)