Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 8i EJB SecurityException

Re: Oracle 8i EJB SecurityException

From: Doeni <doeni_at_evhr.net>
Date: Thu, 22 Jul 1999 20:29:59 +0200
Message-ID: <37976327.507A85AC@evhr.net>


jeff_dodgen_at_my-deja.com wrote:
>
> Doeni,
> Do you know how to grant these roles on NT?

connect system/manager
grant JAVASYSPRIV,JAVAUSERPRIV to SCOTT

In the example I assume the EJBs are run as SCOTT. I'm not sure if SYSTEM has the roles granted. You can do a
SELECT * FROM user_role_privs
or
SELECT * FROM user_sys_privs
to see the user's roles/privileges.

> In article <379611E0.17773650_at_evhr.net>,
> Doeni <doeni_at_evhr.net> wrote:
> > jeff_dodgen_at_my-deja.com wrote:
> > >
> > > I've run a simple "hello world" type scenario successfully, but when
> my
> > > NT Session Bean attempts any NT file IO (new RandomAccessFile(name,
> "r")
> > > or new FileInputStream(name).tostring()) I get the following error:
> > >
> > > Calling MyEJB methods...
> > > Caught RuntimeException in remote method; nested exception is:
> > > java.lang.SecurityException:null
> > > Remote Stack Trace:
> > > java.lang.SecurityException
> > > at
> > >
> oracle.aurora.rdbms.SecurityManagerImpl.checkRole(SecurityManagerImpl.ja
> > > va)
> > > at
> > >
> oracle.aurora.rdbms.SecurityManagerImpl.checkConnect(SecurityManagerImpl
> > > .java)
> > > at java.net.InetAddress.getAllByName0(InetAddress.java)
> > > at java.net.InetAddress.getByName(InetAddress.java)
> > > at java.net.Socket.<init>(Socket.java)
> > > at weblogic.jdbc.common4.sql.BaseConnection.<init>
> > > at weblogic.jdbc.common4.sql.TdsConnection.<init>
> > > at weblogic.jdbc.common4.sql.MicrosoftConnection.<init>
> > > at weblogic.jdbc.microsoft4.Driver.newConnection
> > > at weblogic.jdbc.common4.sql.ConnectDriver.connect
> > >
> > > So I attempted to set runAsMode =SYSTEM_IDENTITY in descriptor but
> > > deploying that I get: "You must be SYS to grant runAs identity of
> SYS"
> > >
> > > Please help.
> > >
> > > Thanks,
> > > Jeff
> > >
> > > Sent via Deja.com http://www.deja.com/
> > > Share what you know. Learn what you don't.
> >
> > The user that executes the bean needs to have either the JAVASYSPRIV
> or
> > JAVAUSERPRIV roles granted. I don't remember the difference between
> > both.
> > This roles are required to write to disk, write to sockets ...
> >
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Thu Jul 22 1999 - 13:29:59 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US