Re: Trigger AND CREATE USER (dynamic SQL)

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 13 Jan 2001 19:40:51 +0100
Message-ID: <93rn39$bb324$1@ID-62141.news.dfncis.de>

create or replace procedure create_user (p_user in varchar2) is cur_handle binary_integer := dbms_sql.open_cursor; res binary_integer;
sqlstr varchar2(2000);
begin
sqlstr := 'CREATE USER '||p_user||' identified by password'; -- etc dbms_sql.parse(cur_handle, sqlstr, dbms_sql.native); res := dbms_sql.execute(cur_handle);
dbms_sql.close_cursor(cur_handle);
exception
when others then
if cur_handle > 0 then dbms_sql.close_cursor(cur_handle); end;
/

Hth,

Sybrand Bakker, Oracle DBA

"Manuel" <manuelbaena_at_airtel.net> wrote in message news:3A605F55.EB4BDC09_at_airtel.net...
> I'm use Oracle 8.
> I need create a new user when a trigger run.
> Can someone help me?
>
> RE to:
> manuelbaena_at_airtel.net
>
>
Received on Sat Jan 13 2001 - 12:40:51 CST