Home » Developer & Programmer » Forms » Creating User from FORMS !!
Creating User from FORMS !! [message #80650] Sat, 26 October 2002 01:18 Go to next message
Qavi
Messages: 24
Registered: August 2002
Junior Member
Hello Friends ,
i want to create user from FORMS rather than creating them from SQL / OEM .. i have tried it usinf FORMS_DDL but its failing ..can u find any error in my code or may be the whole procudeure i selected must be wrong can any1 post me proper way to create the users all r appritiated ,Thx in advance

Note :: code which i wrote

BEGIN
Forms_DDL('CREATE USER :DBA_USERS.USERNAME IDENTIFIED BY :DBA_USERS.PASSWORD
DEFAULT TABLESPACE USER_DATA
TEMPORARY TABLESPACE TEMPORARY_DATA');

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

Qavi.
Re: Creating User from FORMS !! [message #80652 is a reply to message #80650] Sat, 26 October 2002 22:48 Go to previous messageGo to next message
Qavi
Messages: 24
Registered: August 2002
Junior Member
Dear Friends ,

I got it when i do like this
BEGIN
Forms_DDL('CREATE USER '||:DBA_USERS.USERNAME|| ' IDENTIFIED BY '||:DBA_USERS.PASSWORD||'
DEFAULT TABLESPACE USER_DATA
TEMPORARY TABLESPACE TEMPORARY_DATA');

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

Rgds
Qavi
Re: Creating User from FORMS !! [message #80661 is a reply to message #80650] Mon, 28 October 2002 11:30 Go to previous message
Zaire
Messages: 36
Registered: October 2002
Member
Tried allocating a limit on the tablespaces:

quota 1M on USER_DATA
Previous Topic: Passing Parameters
Next Topic: urgent:!!
Goto Forum:
  


Current Time: Wed Oct 20 18:55:24 CDT 2021