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 Producer and Consumer?
What is JMS API Architecture?
What is jms and mq?
What is jms (java messaging service)?
What is the basic difference between Publish Subscribe model and P2P model?
What is the publish-and-subscribe model in jms?
What are the different types of messages available in the JMS API?
How to check jms messages in weblogic?
What are the types of messaging?
What is object message ?
What is a messaging service?
What is the jms client?