Re: Create user in stored procedure

Hi Terry,
You need to use dbms_sql to do this
general outline in your case
cur_handle integer;
cur_handle := dbms_sql.open_cursor;
dbms_sql.parse(cur_handle,'create user blabla', dbms_sql.native); dbms_sql.close_cursor(cur_handle);

Hth
Sybrand Bakker, Oracle DBA

Terry Sharp <tsharp_at_witsys.com> wrote in message news:7mfgjn$fi3$1_at_ffx2nh4.news.uu.net...
> I have a procedure that accepts two varchar2 variables as input (say a
> v_login and v_password). I check to see if the login exists in dba_users.
> If not I'd like to issue the create user v_login identified by v_password
> command within the stored procedure. Is there a way to do this?
>
> TIA
>
> --
> Terry Sharp, Data Architect
> Witness Systems, Inc.
> ph: 770-754-1911
> fax: 770-754-1888
> tsharp_at_witsys.com
>
>
Received on Tue Jul 13 1999 - 13:26:42 CDT