| Creating User from FORMS !! [message #80650] |
Sat, 26 October 2002 01:18  |
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  |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
