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 is subdeployment in weblogic jms?
Explain about publish model?
Are foreign destinations handled within foreign jms messages?
Why do we use jms?
Explain about message selector?
List types of Messaging services supported by JMS?
How to check jms messages in weblogic?
How the jms is different from rpc?
What is jndi? How is it related to jms?
What is jms template?
What is a bytes message?
Which types of jdbc databases does weblogic jms support?
What do you mean by Synchronous and Asynchronous type of messaging?
What is jms producer?
What is mean by jms?