CREATE OR REPLACE PROCEDURE Fails With ORA-1031
Last updated on NOVEMBER 10, 2016
Applies to:Oracle Server - Enterprise Edition - Version: 10.2.0.4 to 22.214.171.124
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.
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