Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Connect Through PLSQL with different user question
faheemrao,
Can you please be more specific , I read all of them but I could not
find the answer .
Do you mean DBMS_SQL package, if so, I think EXECUTE IMMEDIATE is
easier to use,
Once again , Thank you very much
Khaled
In article <8vf871$kdf$1_at_nnrp1.deja.com>,
faheemrao_at_my-deja.com wrote:
> 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.
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Tue Nov 21 2000 - 21:52:46 CST