In Forms 6i (d2k) I created the userid and password. How to create a new user and password programatically?
One of the best ways to accomplish this is to create a stored procedure which will accept the username and password and then create the new user. Such a procedure might look like the following:
CREATE OR REPLACE PROCEDURE create_new_user
(usernm IN VARCHAR2, passwd IN VARCHAR2)
sql_stmt := 'CREATE USER '||usernm||' IDENTIFIED BY '||passwd
EXECUTE IMMEDIATE sql_stmt;
Now that you have the procedure defined, you can call it in your application, passing the username and passwords as parameters.
Dig Deeper on Oracle database design and architecture