Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle AQ: PLSQL Callback to be executed as current user / definer

Hi,

I'm implementing asynchronous processing using AQ - PL/SQL callback method. Noticed that the callback procedure is executed from SYS user and not from current_user/definer.

Is there anyway to change this behaviour so that the callback procedure is executed as the schema where the procedure is defined? Thank you

P.S: Solution was built based on https://asktom.oracle.com/ords/f?p=100:11:0::::P11_QUESTION_ID:8760267539329 and https://markhoxey.wordpress.com/2016/03/01/asynchronous-processing-using-aq-callback/

Comments
Post Details
Added on Mar 26 2025
0 comments
83 views