PL/SQL,Trigger,CREATE

hello :)!
i want to create a trigger, which "creates" an user with password.... and don't want to use a library. can someone help me pls. :)

CREATE TABLE table_name(
  password VARCHAR2(8),
  username VARCHAR2(8)
);

CREATE OR REPLACE PROCEDURE create_user(usr VARCHAR2, passwort VARCHAR2) AS

  cursor_name NUMBER;
  ret NUMBER;

BEGIN
  cursor_name := DBMS_SQL.OPEN_CURSOR;
  DBMS_SQL.PARSE(cursor_name,'CREATE USER '||usr||' identified by '||passwort,DBMS_SQL.NATIVE);
  ret := DBMS_SQL.EXECUTE(cursor_name);   DBMS_SQL.CLOSE_CURSOR(cursor_name);

  cursor_name := DBMS_SQL.OPEN_CURSOR;
  DBMS_SQL.PARSE(cursor_name,'Grant create session to '||usr,DBMS_SQL.NATIVE);
  ret := DBMS_SQL.EXECUTE(cursor_name);   DBMS_SQL.CLOSE_CURSOR(cursor_name);
END;
/

CREATE OR REPLACE TRIGGER t_test
BEFORE INSERT ON table_name FOR EACH ROW

BEGIN
  create_user(:NEW.username,:NEW.password); END t_test;
/

THANX, sorry, my english is not well :( Received on Wed Oct 20 1999 - 17:22:11 CDT