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


Please Help Members By Posting Answers For Below Questions

What is subdeployment in weblogic jms?

528


Explain about publish model?

527


Are foreign destinations handled within foreign jms messages?

535


Why do we use jms?

428


Explain about message selector?

525






List types of Messaging services supported by JMS?

439


How to check jms messages in weblogic?

474


How the jms is different from rpc?

479


What is jndi? How is it related to jms?

488


What is jms template?

475


What is a bytes message?

496


Which types of jdbc databases does weblogic jms support?

446


What do you mean by Synchronous and Asynchronous type of messaging?

506


What is jms producer?

492


What is mean by jms?

476