Oracle DBMS_JAVA_DEV
Version 23c

General Information
Library Note Morgan's Library Page Header
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
Subprograms
 
DISABLE
Disables grants to the ORACLE_JAVA_DEV role dbms_java_dev.disable;
exec dbms_java_dev.disable;
 
ENABLE
Enables grants to the ORACLE_JAVA_DEV role dbms_java_dev.enable;
exec dbms_java_dev.enable;

Related Topics
Built-in Functions
Built-in Packages
DBMS_JAVA
DBMS_JAVA_DUMP
DBMS_JAVA_MISC
DBMS_JAVA_TEST
OJDS_NAMESPACE
What's New In 21c
What's New In 23c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2023 Daniel A. Morgan All Rights Reserved
  DBSecWorx