Granting The Execute Privilege On SYS Owned Packages Fails With ORA-01031 On 11.2.0.3.0

(Doc ID 1393228.1)

Last updated on OCTOBER 13, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 11.2.0.3 and later [Release: 11.2 and later ]
Information in this document applies to any platform.

Symptoms

Starting with RDBMS version 11.2.0.3, after granting EXECUTE WITH GRANT OPTION on certain SYS owned packages to a user, that user cannot grant execute on the package to another user anymore, for example:

$ sqlplus / as sysdba



SQL*Plus: Release 11.2.0.3.0 Production on Tue Jan 10 13:28:48 2012



SQL> create user DBA_MARC identified by manager;



User created.





SQL> grant create session to DBA_MARC;



Grant succeeded.





SQL>  grant  execute on SYS.DBMS_SCHEDULER  to DBA_MARC with grant option;



Grant succeeded.



SQL> create user USER_MARC identified by manager;



User created.



SQL> connect DBA_MARC/manager

Connected.

SQL> grant EXECUTE ON SYS.DBMS_SCHEDULER TO USER_MARC;



ERROR at line 1:

ORA-01031

Changes

This issue is introduced after upgrading to version 11.2.0.3.

Cause

	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