My Oracle Support Banner

CREATE OR REPLACE PROCEDURE Fails With ORA-1031 (Doc ID 758303.1)

Last updated on MARCH 04, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.4 and later
Information in this document applies to any platform.
This problem can occur on any platform.

Symptoms

 

Database is 10.2.0.4 or higher. You have granted the user ALTER ANY PROCEDURE system privilege. But this user is unable to modify the procedure with CREATE OR REPLACE in another user's schema and gets ORA-01031 error.

However, in 10.2.0.3 or lower, with the ALTER ANY PROCEDURE privilege the user is able to execute CREATE OR REPLACE on another user's schema object.

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