Why doesn't AQ_ADMINISTRATOR_ROLE or AQ_USER_ROLE always work for AQ applications using Java/JMS API?
Answer Posted / 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 |
Post New Answer View All Answers
Why is my jms work not part of a user transaction (i.e., Called within a transaction but not rolled back appropriately)? How do I track down transaction problems?
Explain the difference between topic and queue?
What is a jms connection?
How does jms queue work?
What is the functionality of a message listener in the context of jms?
What are the types of messages that are supported by JMS?
What is the difference between jms and kafka?
What are the steps to send and receive JMS message ?
What is difference between jms and activemq?
What is spring jms?
What are all the features of JMS API in J2EE platform?
Explain about Connection factory interface?
What is jms in java with example?
What is mean by jms?
What are the different places where you can use the JMS API?