Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

Why is my jms work not part of a user transaction (i.e., Called within a transaction but not rolled back appropriately)? How do I track down transaction problems?

893


Explain the difference between topic and queue?

1024


What is a jms connection?

893


How does jms queue work?

883


What is the functionality of a message listener in the context of jms?

865


What are the types of messages that are supported by JMS?

876


What is the difference between jms and kafka?

902


What are the steps to send and receive JMS message ?

1419


What is difference between jms and activemq?

925


What is spring jms?

882


What are all the features of JMS API in J2EE platform?

955


Explain about Connection factory interface?

961


What is jms in java with example?

943


What is mean by jms?

960


What are the different places where you can use the JMS API?

888