Re: Questions about PL/Sql stored procedures

That's what I suspected, also.
What about the capability of identifying the caller, from inside the procedure? I mean the database login of the invoker....

Chris

In article <ybdz5.43317$W45.3964441_at_typhoon.tampabay.rr.com>,   "John Alexander" <jalexander_at_summitsoftwaredesign.com> wrote:
> You can write a database procedure that creates a user and grants
> privileges. However, you can't change the user login within a database
> procedure. You need to either drop back to sqlplus or forms to change
 who
> you are logged in as.
>
> John Alexander
> www.SummitSoftwareDesign.com
>
> <chrisoc_at_iclick.com> wrote in message

 news:8qjlm3$7b1$1_at_nnrp1.deja.com...
> >
> >
> > Is it possible for a stored procedure to tell who
> > has called it?
> >
> > Is it possible for a stored procedure that is run by
> > a user with DBA privileges to create a user, set
> > a password and some basic privileges for that user,
> > and then connect as that user and do some more DDL
> > and DML? Or would that second connection have to
> > be done from "outside", say in a SQL*Plus procedure?
> >
> > Chris O'Connor
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
> >
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sun Sep 24 2000 - 09:46:32 CDT