Why doesn't AQ_ADMINISTRATOR_ROLE or AQ_USER_ROLE always work for AQ applications using Java/JMS API?



Why doesn't AQ_ADMINISTRATOR_ROLE or AQ_USER_ROLE always work for AQ applications using Java/JM..

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

Post New Answer

More JMS Interview Questions

What is a bytes message?

0 Answers  


What is mean by jms?

0 Answers  


How is message oriented middleware responsible for no time dependency between sender and receiver component with respect to point to point model on jms?

0 Answers  


Must I place all my class files in the WEB-INF folder and all JSP's outside?

0 Answers   Nigerian Ports Authority,


What is jms broker in sas?

0 Answers  






Are foreign destinations handled within foreign jms messages?

0 Answers  


What is the difference between topic and queue?

1 Answers  


Which are the benefits of mdb (message driven beans) over standard jms consumers?

0 Answers  


What is ems queue?

0 Answers  


Does kafka support jms?

0 Answers  


How you can deliver a java message to a non-java client?

0 Answers  


What is the principle difference between the working mechanism of jms and rpc?

0 Answers  


Categories