Create automatic script

[sqlnubie3]

Okay experts I am in need of help as I am just learning SQL. I currently create and grant users to the Oracle 10g BI tool. Right now it is a very manual process. As new emloyees begin weekly, I am in need of a script that will save me time. There are several steps I must take and I find that miss a few.

Step 1: create user cheyenne identified by cheyenne;
Step 2: alter user cheyenne default role all;
Step 3: grant disco_finance_su to cheyenne;
Step 4: grant disco_db_user to disco_finance_su;

There has to be a way I can automate this when a new employee needs to have access to Discoverer. Please help

nubie3

[POS]

hello what environemnt do you carry out the 4 tasjks above ie, unix,sql plus on live or other gui.

[sqlnubie3]

Hello,

I use the four scripts in an Oracle environment using SQL. I have figured out that I need to use subqueries--very new at that--and a $$prompt to look for the last name which will then be used in the subqueries to run the script. That's about all I know at the moment.

Thanks for your help!