Creating new user and password in Forms 6i

In Forms 6i (d2k) I created the userid and password. How to create a new user and password programatically?

    Requires Free Membership to View

    Login

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)
AS
   sql_stmt VARCHAR2(100);
BEGIN
   sql_stmt := 'CREATE USER '||usernm||' IDENTIFIED BY '||passwd
   EXECUTE IMMEDIATE sql_stmt;
END;
/
Now that you have the procedure defined, you can call it in your application, passing the username and passwords as parameters.

This was first published in November 2006

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top