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 text message?
What is jms queue?
What are Building Blocks of a JMS application?
What is the difference between the P2P (Peer to Peer) model and subscribe model?
Explain how Application server handles the JMS Connection?
What are the components of JMS?
Explain JMS and its Component?
What is the use of message queues?
What is the difference between an sms and text message?
Mention different types of messages available in JMS API?
Which jms standard interface defines the methods to create the different types of messages?
What are the various message types supported by JMS?