Execute With Grant Option Does not Work for Some Packages in 184.108.40.206 (ORA-01031)
(Doc ID 1369355.1)
Last updated on FEBRUARY 03, 2019
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 and later
Information in this document applies to any platform.
In 18.104.22.168, the execute with grant option object privilege does not work for some system packages:
SQL> create user test2 identified by test2;
SQL> grant connect,resource to test;
SQL> grant execute on dbms_standard to test with grant option;
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 22.214.171.124
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document