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 check messages in jms queue?
What is jms connection factory in weblogic?
What type of messaging is provided by JMS?
Mention different types of messages available in JMS API?
What is jms queue in java?
What is hermes software?
What is a topic?
What is a connection factory?
Can we send message from one server to another server using jms?
How do I configure jdbc so that the jms jdbc store recovers automatically?
Which messaging modes are included in the java messaging service jms )?
How can an application do a jms operation and have it succeed, independent of the result of the transaction?
Name the messaging types supported by jms.
What is message listener container?
Wat is jms client?