Database Administration (MOSC)

MOSC Banner

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center