DBA_AQ_AGENT_PRIVS displays information about the registered AQ agents that are mapped to all users in the database.
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 |
|
|
|
| Name of the AQ agent |
|
|
| | Name of the database user that the agent maps to |
|
|
| | Indicates whether the agent is allowed to access AQ through HTTP ( |
|
|
| | Indicates whether the agent is allowed to access AQ through SMTP ( |
Note:
1.
select * from DBA_AQ_AGENT_PRIVS;
| AGENT_NAME | DB_USERNAME | HTTP_ENABLED | SMTP_ENABLED |
| HAE_SUB | | NO | NO |
| SCHEDULER$_EVENT_AGENT | SYS | NO | NO |
| SERVER_ALERT | SYS | NO | NO |
No comments:
Post a Comment