DBA Data[Home] [Help]

MDSYS.SDO_ROUTER_PARTITION dependencies on DBMS_JAVA

Line 145: dbms_java.grant_permission(

141:
142: -- Grant privileges to the directory to the Router user and MDSYS
143: stmt := 'GRANT read, write ON DIRECTORY sdo_router_log_dir TO ' || UPPER(SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(router_schema));
144: EXECUTE IMMEDIATE stmt;
145: dbms_java.grant_permission(
146: UPPER(SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(router_schema)), 'java.io.FilePermission',
147: directory_path, 'read,write');
148:
149: EXECUTE IMMEDIATE 'GRANT read, write ON DIRECTORY sdo_router_log_dir TO MDSYS';

Line 150: dbms_java.grant_permission(

146: UPPER(SYS.DBMS_ASSERT.SIMPLE_SQL_NAME(router_schema)), 'java.io.FilePermission',
147: directory_path, 'read,write');
148:
149: EXECUTE IMMEDIATE 'GRANT read, write ON DIRECTORY sdo_router_log_dir TO MDSYS';
150: dbms_java.grant_permission(
151: 'MDSYS', 'java.io.FilePermission',
152: directory_path, 'read,write');
153:
154: END create_sdo_router_log_dir;