Re: UserName control from procedures...

From: Sharma, Lakshmikant LK <sharma.lakshmikant.lk_at_bhp.com.au>
Date: 1996/12/20
Message-ID: <01bbee12$af0ce320$e0331286@ITCBR_005.itcbr.bhp.com.au>#1/1

Have tried using the DBMS_SQL packages for dynamic sql to achieve this. I have not used it but I am sure you should be able to use it.

Thanks
Lakshmikant Sharma

Chad M. Hegerty <t75cmh1_at_sr-server.rossnutrition.com> wrote in article <01bbede9$177420b0$282b10ac_at_chegerty>...
> We wish to set up a package containing stored procedures to add new users
> to our database and also to allow changing of the passwords. We wish to
put
> these items in a package so that we can call them from our application
> program (written in Powerbuilder and/or VB). We found out that the ALTER
> command (and I assume the CREATE USER command) cannot be called from
within
> a PL/SQL code block.
>
> Is there a way to issue ALTER USER and CREATE USER commands from within a
> procedure/function? What are some ways that this can be accomplished?
>
> We would like the users to be able to add a user to our system and have
> that user added to ORACLE via a CREATE USER command. Can this be done?
>
> Thanks in advance...
> ---
> Chad M. Hegerty (t75cmh1_at_sr-server.rossnutrition.com)
> Phone: 614.624.3988
> Fax: 614.624.5675
>
Received on Fri Dec 20 1996 - 00:00:00 CST