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

(Doc ID 1369355.1)

Last updated on JULY 31, 2017

Applies to:

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


In, 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
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:


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


upgrade to


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