Execute With Grant Option Does not Work for Some Packages in 126.96.36.199 (ORA-01031)
(Doc ID 1369355.1)
Last updated on MARCH 02, 2019
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
In 184.108.40.206, the execute with grant option object privilege does not work for some system packages:
SQL> create user test2 identified by XXXX;
SQL> grant connect,resource to test;
SQL> grant execute on dbms_standard to test with grant option;
SQL> conn test/XXXX
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 220.127.116.11
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