|
|
|
Re: can anybody help me out... [message #82304 is a reply to message #82272] |
Fri, 16 May 2003 02:00 |
BIRENDER KUMAR
Messages: 18 Registered: May 2003
|
Junior Member |
|
|
Inorder to execute sql ddl commands use
FORMS_DDL buit-in.
This is a very powerfull buit-in.
use this code:
BEGIN
Forms_DDL('create user x identified by x');
IF NOT Form_Success THEN
Message ('user Creation Failed');
ELSE
Message ('user Created');
END IF;
END;
If u wish to create n no of user thru form
use :text_item in place of x
Note :You should have sufficent previlages to create user.
If not working e-contact me.
|
|
|
Re: can anybody help me out. [message #84350 is a reply to message #82304] |
Sun, 07 March 2004 01:05 |
fouzia
Messages: 3 Registered: February 2002
|
Junior Member |
|
|
I use this command to create user in forms
it work perfectly but when I add this command
'DEFAULT tablespace dat temporary tablespace ts_temp'
the user is not created
please help me
|
|
|