4 Replies Latest reply: Sep 5, 2012 3:01 PM by 758358 RSS

    PL*SQL notification of Advanced Queues. Not using SYS user

    Greg Block

      When using advanced queues and pl*sql notification, I use the dbms_aq.register procedure to specify what routine I'd like to call.
      That all works and I have no problems.
      However, when run, the procedure I specify runs as the SYS user. Is there are way to change the user that is used to run the routine? I'd like one of my own database users (rather than SYS) to run it.