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 asynchronous messaging in jms?
How can third-party jdbc driver be used with jms?
What is the important part of JMS applications?
What are all the features of JMS API in J2EE platform?
Does JMS specification define transactions?
What is a message in software?
What is the difference between Jms and Jvt ?
What is the use of JMS? In which situations we are using JMS? Can we send message from one server to another server using JMS?
What is poison messages? And how to handle poison messages?
Is rabbitmq a jms?
What is jms correlation id?
Which are the benefits of mdb (message driven beans) over standard jms consumers?