Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Connect Through PLSQL with different user question
I don't think you are going to find a package to do this. If you do, let me know because it would help me. Would creating a database link as that user and then accessing it in your package work? Otherwise you might look at dba_users and see if the password expire information is in there and write a package that compares the password expire date to sysdate for a given user.
In article <8vffuc$qbv$1_at_nnrp1.deja.com>,
kachkar_at_my-deja.com wrote:
> 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.
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Wed Nov 22 2000 - 09:22:46 CST