Granting The Execute Privilege On SYS Owned Packages Fails With ORA-01031 On 22.214.171.124.0
(Doc ID 1393228.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Server - Enterprise Edition - Version: 126.96.36.199
Information in this document applies to any platform.
$ sqlplus / as sysdba
SQL*Plus: Release 188.8.131.52.0 Production on Tue Jan 10 13:28:48 2012
SQL> create user DBA_MARC identified by manager;
SQL> grant create session to DBA_MARC;
SQL> grant execute on SYS.DBMS_SCHEDULER to DBA_MARC with grant option;
SQL> create user USER_MARC identified by manager;
SQL> connect DBA_MARC/manager
SQL> grant EXECUTE ON SYS.DBMS_SCHEDULER TO USER_MARC;
ERROR at line 1:
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