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
How do I find the jms queue in weblogic?
What is message listener?
How does a message queue work?
What is jms jndi?
What is MOM in reference to JMS?
What is mdb in jms?
What is the advantage of persistent message delivery compared to nonpersistent delivery?
Explain Asynchronous Message Consumption in JMS?
Explain JMS and its Component?
What is a distributed queue?
What is mean by jms?
What is a topic string?
What is difference between jms and activemq?
What is jms in websphere?
How is message oriented middleware responsible for no time dependency between sender and receiver component with respect to point to point model on jms?