My Oracle Support Banner

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

Last updated on SEPTEMBER 25, 2020

Applies to:

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



Database is 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 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

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