Oracle DBMS_JAVA_DEV
Version 21c

General Information
Library Note Morgan's Library Page Header
Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
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_STANDARD V$PARAMETER
DBMS_ASSERT    
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 19c
What's New In 20c-21c

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-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx