Re: Connect Through PLSQL with different user question

I think you can do this with

DBMS packages , search the package that solve the problem.

In article <8vf6vb$jdp$1_at_nnrp1.deja.com>,   kachkar_at_my-deja.com wrote:
> In article <8vf4f9$h9g$1_at_nnrp1.deja.com>,
> mkrolewski_at_rosetta.org wrote:
> > In article <8vf32m$g95$1_at_nnrp1.deja.com>,
> > kachkar_at_my-deja.com wrote:
> > > Hi all,
> > >
> > > Is it possible in PLSQL through stored procedures to connect to
 the
> > > database with different user. I’ve tried this EXECUTE
> > > IMMEDIATE 'Connect john/test' ;
> > > But it did not work
> > > All I want to do is when user X ( he owns the procedure ) calles
 the
> > > stored procedure , that stored procedure try to connect user Y to
 the
> > > database that is all .
> > >
> > > So is it possible to achieve this task through PLSQL and if Yes
 please
> > > show me how.
> > >
> > > Thanks in advance
> > >
> > > Khaled
> > >
> > > Sent via Deja.com http://www.deja.com/
> > > Before you buy.
> > >
> >
> > Your question appears to be mechanism to circumvent the entire
 security
> > scheme. Why does a specific user need to be logged in as another?
> > Generally, roles and grants can accomplish any authorized transfer
 of
> > privilege.
> >
> > Michael Krolewski
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
> >
>
> Michael ,
> The client application can not trap error ora-28002 : the password
 will
> expire within 5 days
> So I need to use stored procedure to trap that error then pass it to
 my
> application so I can inform the user about that.
> That is why , again , can I do that or not ?
> Thank you
> Khaled
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Nov 21 2000 - 19:40:50 CST