-- actions to upgrade 9.2.0 components to 10.1.0

-- add preferences schema objects
@@initprefs

-- jvmsec3 additions

-- Logging
call dbms_java.grant_policy_permission('JAVA_ADMIN', 'SYS', 'java.util.logging.LoggingPermission', '*');

-- Allows JAAS authenitcation
call dbms_java.grant_policy_permission('JAVA_ADMIN', 'SYS', 'javax.security.auth.AuthPermission', '*');

-- Headless AWT
call dbms_java.grant_policy_permission('JAVA_ADMIN', 'SYS', 'java.awt.AWTPermission', '*');

-- JSSE
call dbms_java.grant_policy_permission('JAVA_ADMIN', 'SYS', 'javax.net.ssl.SSLPermission','*');

-- Security Permission
call dbms_java.grant_policy_permission('JAVA_ADMIN', 'SYS', 'java.security.AllPermission', '*');


-- All users can use Preferences
call dbms_java.grant_permission('PUBLIC', 'SYS:java.lang.RuntimePermission','preferences', null);

-- jvmsec5 additions

-- Secure Socket Perms for SYS
call dbms_java.grant_permission('SYS', 'SYS:javax.net.ssl.SSLPermission', '*', null);

--- In jdk1.4  neede for RMI runtime.
call dbms_java.grant_permission('SYS','SYS:java.util.logging.LoggingPermission', 'control', '');

-- grant sys all Authentication permissions for JAAS
call dbms_java.grant_permission('SYS','SYS:javax.security.auth.AuthPermission', '*', '');

-- grant AllPermission to SYS
call dbms_java.grant_permission('SYS', 'SYS:java.security.AllPermission', '*', null);

-- grant permission to add loadLibrary permissions for SYS

call dbms_java.grant_permission('SYS', 'SYS:oracle.aurora.rdbms.security.PolicyTablePermission', '0:java.lang.RuntimePermission#loadLibrary.*', null);

call dbms_java.grant_permission('SYS', 'SYS:java.lang.RuntimePermission', 'loadLibrary.*', null);

-- Add loading of natives in jox10oraawt oraawt is depricated but it is
-- not necessary to remove the permission to load it.
call dbms_java.grant_permission('SYS', 'SYS:java.lang.RuntimePermission', 'loadLibrary.jox10oraawt', null);

-- Add permission for SYS to load JAAS natives
call dbms_java.grant_permission('SYS', 'SYS:java.lang.RuntimePermission', 'loadLibrary.orajaas', null);


-- revoke abiltity to add loadLibrary permissions
call dbms_java.revoke_permission('SYS', 'SYS:java.lang.RuntimePermission', 'loadLibrary.*', null);

call dbms_java.revoke_permission('SYS', 'SYS:oracle.aurora.rdbms.security.PolicyTablePermission', '0:java.lang.RuntimePermission#loadLibrary.*', null);

-- actions to upgrade 10.1.0 components to 10.2.0
@@jvma101