script to create new user with existing user
Posted on 2008-09-30
Would someone has a script which should do the following;
Complete the script to create a new user based on another user. These are the requirements for the script:
1-One pl/sql script should do everything
Parameters are: new username, new user password, current user to copy
2-The script should only be used to create "qry" accounts .
3-The script should create the user, set the profile, grant system privs, grant roles privs (all roles should be on by default), grant table privs, grant column privs
4-Lastly, it should display the user account information, all system privs, all roles privs, table and column privs (priv, table_name, column_name only) for both the existing and new user for comparison.
I urgently need for step 2 . Would someone help me ?
Great thanks in advance.