ORA-01031: insufficient privileges

Error:

ORA-01031: insufficient privileges

When: 

While compiling a procedure/package/function

Solution:


Even after granting privileges like CREATE PROCEDURE / CREATE ANY PROCEDURE or EXECUTE / EXECUTE ANY PROCEDURE , ORA-01031 is faced. 

Such issue is common whenever accessing cross owned objects for modification. 

Here, CSSSAP is accessing CSS owned objects for modification without appropriate privileges

Granting ALTER ANY PROCEDURE helps to over come the insufficient privilege error as below :

SQL>  alter procedure CSS.PROC_ACCESSD compile;

 alter procedure
CSS.PROC_ACCESSD compile
*
ERROR at line 1:
ORA-01031: insufficient privileges

SQL> grant ALTER ANY PROCEDURE to csssap;

Grant succeeded.

SQL> SQL> conn csssap/********

Connected.
SQL> alter procedure CSS.PROC_ACCESSD compile;

Procedure altered.

SQL>

 


No comments:

Post a Comment