What privileges required to consume events from the SYS.SCHEDULER$_EVENT_QUEUE?
I am trying to cause a scheduler job to be executed in response to the completion status of another job. I have found plenty of examples of how to do this and understand the basics, but I can't seem to figure out what privileges my database user needs.
I am getting "ORA-27375: valid agent name must be specified for secure queues" when I try to schedule the job that reacts to the event. It works fine if I use a different (admin) user for the agent with (many) more privileges and roles. I am just trying to figure out what privileges and/or roles I need to give my application user. Can anyone give general guidance on this? The documentation is somewhat vague. Thanks.