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 a jms listener?
What is the difference between Jms and Jvt ?
What is a remote jms provider?
What is the use of jms? In which situations we are using jms?
What is jms connection?
What are the functionalities of a jms provider?
What is a topic string?
What is jms and mq?
What is the use of EventMessage.java?
Explain about the exception handling mechanism of JMS?
What is the basic difference between Publish Subscribe model and P2P model?
Can we send e-mail messages using JMS?