DBMS_SCHEDULER.ADD_JOB_EMAIL_NOTIFICATION FAILS WITH ORA-01031 INSUFFICIENT PRIVILEGES
Last updated on DECEMBER 25, 2016
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 and later
Information in this document applies to any platform.
***Checked for relevance on 25-Dec-2016***
Trying to create email notifications from a user into another user schema fails with ORA-01031: insufficient privileges
- Create a job with user A
- Grant Create Any Job to user B
- Call add_job_email_notification with user B about the job that A created.
This will fail with ORA-01031: insufficient privileges.
However The email notification will work only if the first schema to create an email notification is the job owner's schema.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms