Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Connect Through PLSQL with different user question
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.
Received on Tue Nov 21 2000 - 19:19:44 CST