My Oracle Support Banner

Explicitly Grant EXECUTE on SYS Packages to interMedia/Oracle Multimedia Users (Doc ID 878093.1)

Last updated on FEBRUARY 14, 2022

Applies to:

Oracle Multimedia - Version and later
Information in this document applies to any platform. *** ***


It might happen that, by accident, some grants on fundamental SYS objects, are revoked from PUBLIC.

In a possible scenario, this problem might occur if 'EXECUTE ANY PROCEDURE' is revoked from
PUBLIC role.

The result, from an interMedia/Oracle Multimedia perspective, is that either ORDSYS or ORDPLUGINS
objects might get invalidated and without any chance to be revalidated by re-compiling them.

Usually, in these cases the command

ALTER PACKAGE  <package_name> COMPILE;

would return an error message, such as ORA-04043,  pointing to one of  the SYS objects commonly involved, on which a privilege is missing.

The objects involved are, generally, the following  packages:


Therefore, if ORDSYS and/or ORDPLUGINS objects are found INVALID and cannot be revalidated,
good idea is that of explicitly granting execute on the above packages to the ORDSYS/ORDPLUGINS users and then recompile them.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.