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

Last updated on NOVEMBER 10, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: to
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.


Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms