My Oracle Support Banner

DBMS_SCHEDULER.ADD_JOB_EMAIL_NOTIFICATION FAILS WITH ORA-01031 INSUFFICIENT PRIVILEGES (Doc ID 1662941.1)

Last updated on FEBRUARY 20, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
***Checked for relevance on 25-Dec-2016***

Symptoms

Trying to create email notifications from a user into another user schema fails with ORA-01031: insufficient privileges

 Example:
- 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.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.