Granting the database administrator the EXECUTE privilege on required packages

The database administrator user does not have rights to grant the database user execute privileges on certain required packages. To grant the database administrator the necessary rights, run the following SQL commands as a database superuser:

GRANT EXECUTE on SYS.DBMS_JOB to <Database Administrator user name> WITH GRANT OPTION;
GRANT EXECUTE on SYS.DBMS_LOB to <Database Administrator user name> WITH GRANT OPTION;
GRANT EXECUTE on SYS.DBMS_SQL to <Database Administrator user name> WITH GRANT OPTION;
GRANT EXECUTE on SYS.UTL_FILE to <Database Administrator user name WITH GRANT OPTION;