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
What do you mean by Synchronous and Asynchronous type of messaging?
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?
What is the functionality of a message listener in the context of jms?
Explain how does the JMS work with the J2EE?
Do text messages use data?
What is the difference between jms and mq?
Can we have more than one consumer for a jms queue?
What is a distributed queue?
How to check jms messages in weblogic?
What is the functionality of a jms message selector?
How to Set message priority levels?
Can two different jms services talk to each other? For instance, if a and b are two different jms providers, can provider a send messages directly to provider b? If not, then can a subscriber to provider a act as a publisher to provider b?
What does jms stand for?
Can two jms servers share the same persistent store?
What are jms channels?