ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling
complimentary technical Workshops on Database Security for the first 30
Oracle Database customers located anywhere in North America, EMEA, LATAM, or
APAC that send an email to
asra_us@oracle.com. Request a Workshop for
your organization today.
Purpose
Enables and disable the grants on Java classes to PUBLIC as part of the introduction of a new ORACLE_JAVA_DEV role introduced in version 19c.
This package is not installed by default using DBCA.
AUTHID
DEFINER
Dependencies
DBA_DEPENDENCIES
DBMS_OUTPUT
DBMS_UTILITY
DBA_OBJECTS
DBMS_REGISTRY
PLITBLM
DBA_TAB_PRIVS
DBMS_SESSION
V$PARAMETER
DBMS_ASSERT
DBMS_STANDARD
Documented
No
Exceptions
Error Code
Reason
ORA-1921
Role exists
ORA-2264
constraint_exists
ORA-20031
Java Development Disabled
ORA-20032
ora_script_set,
ORA-20033
'Can not ' || action || ' when JAVAVM is not loaded'
First Available
19c
Security Model
Owned by SYS with no privileges granted
Source
{ORACLE_HOME}/rdbms/admin/dbmsjdev.sql
SQL> @?/rdbms/admin/dbmsjdev.sql
Session altered.
PL/SQL procedure successfully completed.
Trigger created.
View created.
Synonym created.
Grant succeeded.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
Package created.
SP2-0810: Package Body created with compilation warnings
Session altered.
SQL> sho err
Errors for PACKAGE BODY SYS.DBMS_JAVA_DEV:
LINE/COL ERROR
-------- -----------------------------------------------------------------
8/12 PLW-06010: keyword "VALUE" used as a defined name
19/10 PLW-06009: procedure "VERIFY_ORACLE_SCRIPT_PARAM" OTHERS handler
does not end in RAISE
36/10 PLW-06009: procedure "VERIFY_JAVAVM_LOADED" OTHERS handler does not end in RAISE