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 9.2.0.1 and laterInformation in this document applies to any platform.
*** ***
Goal
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:
- UTL_HTTP
- UTL_FILE
- DBMS_LOB
- DBMS_SQL
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.
Solution
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
Goal |
Solution |
References |