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