Re: 2 sids, 2 external procedure listeners

The only way that I can think of is to be have the first shared object fork off another program that is setuid to the ID of the other user.

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> writes:

> "John Dunn" <JLDunn_at_ukgateway.net> wrote in message
> news:3aef05c8$0$15030$cc9e4d1f_at_news.dial.pipex.com...
> > Anyone got any experience of the following :
> >
> > We have 2 SIDS. We want to configure the external procedure listener for 1
> > SID to run as a unix user other than oracle, with the external procedure
> > listener for the other SID still running as the oracle user?
> >
> > John
> >
> >
> >
> >
>
> I am afraid this is not possible. The external procedure listener is nothing
> more than a service provided by the listener, and the listener should run
> under the owner of the oracle executables, hence under the user oracle.
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>
>
>
 

-- 
                                Thanks,
                                Rick
                                Rick Wessman
                                Server Security Group
                                Oracle Corporation
                                rwessman_at_us.oracle.com

     The opinions expressed above are mine and do not necessarily reflect
                         those of Oracle Corporation.