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 are the different types of messages available in the JMS API?
What is jndi? How is it related to jms?
Explain Synchronous Message Consumption in JMS?
What is the use of connection factory in jms?
What is Stream Message ?
How do I use a third-party jdbc driver with jms?
In which situations we are using jms? Can we send message from one server to another server using jms?
For sending messages through JMS, what encryption options are there?
What is Publish/Subscribe approach?
Can you use a foreign jms provider to drive an mdb transactionally?
What are the types of communication provided by jms? Explain in detail.
What is a jms listener?