Execute With Grant Option Does not Work for Some Packages in 11.2.0.3 (ORA-01031) (Doc ID 1369355.1)

Last updated on JULY 31, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

In 11.2.0.3, the execute with grant option object privilege does not work for some system packages:

SQL> create user test identified by test;
User created.
SQL> create user test2 identified by test2;
User created.
SQL> grant connect,resource to test;
Grant succeeded.
SQL> grant execute on dbms_standard to test with grant option;
Grant succeeded.
SQL> conn test/test
Connected.
SQL> grant execute on dbms_standard to test2;
grant execute on dbms_standard to test2
*
ERROR at line 1:
ORA-01031: insufficient privileges


The issue has been reported for number of packages, including:

DBMS_STANDARD
DBMS_SQL
DBMS_UTILITY
DBMS_JOB
DBMS_REPUTIL

The problem can appear as well for system packages from other schemas than sys as well as user created packages.

Changes

upgrade to 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