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 jms destination?
Why do we need jms?
What is the difference between jms and mq?
What is the use of jms?
Explain about JMS queue?
What is jms queue?
What is jms in websphere?
What is wire level protocol?
Explain about message selector?
Which messaging is generally used in cases where a message is published by a producer and consumed by multiple subscribers?
Where is jms used?
Is it possible to create both queues and topics to single jms server? if yes then how it works?
What is the functionality of a jms queue browser?
What is difference between queue and topic in jms?
How many types of messaging model do JMS provide for and what are they?