Re: Questions about PL/Sql stored procedures

From: John Alexander <jalexander_at_summitsoftwaredesign.com>
Date: Sun, 24 Sep 2000 01:56:46 GMT
Message-ID: <ybdz5.43317$W45.3964441@typhoon.tampabay.rr.com>

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.
>
Received on Sat Sep 23 2000 - 20:56:46 CDT