- Open a New excel spread sheet.
- In Column A populate the usernames from User1 to User100. You can use fill series option to generate n number of users.
- In Column B enter the following formula and copy the formula upto B100th column. This will generate the user creation scripts.
- In Column C enter the following formula and copy the formula upto C100th column which will generate the tablespace quota scripts.
- In Column D enter the following formula and copy the formula upto D100th column which will generate the grant scripts.
- Copy the generated scripts into a .sql file and you can run it on SQL prompt.