This content has been marked as final. Show 4 replies
grant execute on dbms_aq to the user that you intend to run the routing
What database version is this?
The database is a 188.8.131.52.6
Granting execute on dbms_aq to the user I want is easily done but how I do specify that is the user that will pick up and process the items in the queue? SYS seems to be a hardcoded default.
Sorry I missed this reply...I found a bug which was fixed in earlier versions than that in use here which should have addressed this:
Procedure invoked by AQ PL/SQL notification is executed as SYS not the Enqueuer (Doc ID 552771.1)
Was this database created newly or upgraded from a previous version?
Just out of interest which user did you perform the registration as?