Rem
Rem $Header: sdogrjar.sql 07-jan-2007.07:29:27 bgouslin Exp $
Rem
Rem sdogrjar.sql
Rem
Rem Copyright (c) 2006, 2007, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      sdogrjar.sql - <one-line expansion of the name>
Rem
Rem    DESCRIPTION
Rem      <short description of component this file declares/defines>
Rem
Rem    NOTES
Rem      <other useful comments, qualifications, etc.>
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    bgouslin    01/07/07 - New version to fix Windoze format issue caused by
Rem                           some ADE bug
Rem    syuditsk    01/29/06 - Created
Rem


SET FEEDBACK 1
SET NUMWIDTH 10
SET LINESIZE 80
SET TRIMSPOOL ON
SET TAB OFF
SET PAGESIZE 100

alter session set current_schema=SYS;

-- add XDB related loads here
call dbms_java.grant_permission('SYSTEM', 'java.io.FilePermission',
                                 '<<ALL FILES>>', 'read');
call dbms_java.grant_permission('MDSYS', 'SYS:java.io.FilePermission', 
                                'md/jlib/*', 'read');

--
-- For NT
--
call dbms_java.grant_permission('MDSYS','SYS:java.io.FilePermission',
                                'md\jlib\*','read');

call dbms_java.grant_permission('MDSYS', 'SYS:java.lang.RuntimePermission', 
                                'getClassLoader', null);
call dbms_java.grant_permission('ORDSYS', 'SYS:java.lang.RuntimePermission', 
                                'getClassLoader', null);

call dbms_java.loadjava('-resolve -force -synonym -schema MDSYS -grant PUBLIC
                        md/jlib/sdogr.jar');

call dbms_java.revoke_permission('MDSYS','SYS:java.io.FilePermission',
                                 'md/jlib/*','read');

commit;

alter session set current_schema=MDSYS;