Re: UserName control from procedures...

"Chad M. Hegerty" <t75cmh1_at_sr-server.rossnutrition.com> writes:
> 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

The DBMS_SQL package lets you create dynamic SQL and issue DDL commands such as CREATE TABLE etc. Should help with this also. Received on Fri Dec 20 1996 - 00:00:00 CST