Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Create user in stored procedure

Re: Create user in stored procedure

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Tue, 13 Jul 1999 20:26:42 +0200
Message-ID: <931890371.14884.0.pluto.d4ee154e@news.demon.nl>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US