Re: java in the database (10gR2 & 11gR2)
Date: Mon, 7 Feb 2011 14:30:22 -0800 (PST)
On Feb 5, 10:25 am, Jeremy <jeremy0..._at_gmail.com> wrote:
> In article <3497fa16-854d-40b2-becb-
> a1cca3cf4..._at_j11g2000yqh.googlegroups.com>, bdb..._at_gmail.com says...
> > Jeremy,
> > > Are there any
> > > difference between 10g and 11g in this respect (as we will need to make
> > > this work in both versions)?
> > Part of upgrading a database to 11g (22.214.171.124 at this point) is to
> > create access control lists for the UTL packages, i.e. UTL_SMTP using
> > the package DBMS_NETWORK_ACL_ADMIN.
> > This would not likely have affected 10g R2, but possibly it was
> > backported into the 10.2.0.5 patchset?
> > You might want to list more detailed version info.
> Thanks for that - DB in which we are evaluating "jc" is running
> 126.96.36.199.0 on Windows Server 2003.
> We are able to access e.g. utl_smtp and utl_http from within PL/SQL no
> problems there.
> Question really at this stage is whether there are any explicit access
> rights that need to be granted in order for java code to be able to
> access these kinds of network functions.
Oracle 11g r2 has introduced many new security requirements. You may need also to "grand" Java classes access to specific internet resources:
dbms_java.grant_permission( <Your Schema>, 'SYS:java.net.SocketPermission', '127.0.0.1:9999', 'connect,resolve' );
Change 'SYS:java.net.SocketPermission' to the class name used to access internet.
Change '127.0.0.1:9999' to the ip or url required. Look at this explanation:
Thomas Received on Mon Feb 07 2011 - 16:30:22 CST