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