Prepare Interview

Mock Exams

Make Homepage

Bookmark this page

Subscribe Email Address

JMS%20Interview%20Questions%20and%20Answers

Question: Why doesn't AQ_ADMINISTRATOR_ROLE or AQ_USER_ROLE always work for AQ applications using Java/JMS API?
Answer: 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 it helpful? Yes No

Most helpful rated by users:

©2024 WithoutBook