Why doesn't AQ_ADMINISTRATOR_ROLE or AQ_USER_ROLE always work for AQ applications using Java/JMS API?
Answer / munnu
In addition to granting the roles, you would also need to grant execute to the user on the following packages:
* grant execute on sys.dbms_aqin to <userid>
* grant execute on sys.dbms_aqjms to <userid>
| Is This Answer Correct ? | 0 Yes | 0 No |
What is jms module in weblogic?
What is Producer and Consumer?
What are the components of JMS?
What is administered objects in jms?
What is jms full form?
What is the functionality of a jms queue browser?
Can a jms queue have multiple listeners?
what is distributed queues and topics and how they works
What does kms mean?
What is queue connection factory?
Wat is jms client?
What is Destination ?