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

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

896


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?

821


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

811


Explain how does the JMS work with the J2EE?

867


Do text messages use data?

819


What is the difference between jms and mq?

830


Can we have more than one consumer for a jms queue?

890


What is a distributed queue?

950


How to check jms messages in weblogic?

924


What is the functionality of a jms message selector?

852


How to Set message priority levels?

1431


Can two different jms services talk to each other? For instance, if a and b are two different jms providers, can provider a send messages directly to provider b? If not, then can a subscriber to provider a act as a publisher to provider b?

981


What does jms stand for?

783


Can two jms servers share the same persistent store?

822


What are jms channels?

783