DYNAMIC USER CREATION -DIMA & MUSTAFA PLS HELP 1

[NITIN27]

HI.
I WANT TO CREATE A USER THROUGH FORMS(FORMS DEVELOPER 6I)
IN A FORM I HAVE TWO FIELDS

USER-IN THIS FIELD USERNAME WILL BE ENTERED
PASS -IN THIS FIELD USER'S PASSWORD WILL BE ENTERED

ON A BUTTON I HAVE WRITTEN A TRIGGER "WHEN-BUTTON-PRESSED"

FORMS_DDL('CREATE USER'||:USER||'IDENTIFIED BY '||ASS);

IF NOT Form_Success THEN
Message ('USER Creation Failed');
ELSE
Message ('USER Created');
END IF;

FORMS_DDL('GRANT CONNECT,RESOURCE TO'||:USER);

PLS. HELP

THANKS IN ADVANCE

 

[lewisp]

You need a space after USER and before IDENTIFIED in [tt]FORMS_DDL('CREATE USER '||:USER||' IDENTIFIED BY '||ASS);[/tt], and after TO in [tt]FORMS_DDL('GRANT CONNECT,RESOURCE TO '||:USER);[/tt]

P.s. Please turn off your caps lock.

 

[NITIN27]

TO LEWISP
THANKS A LOT U ROCKS.