How to create multiple user in Siebel DB using shell script.
Create an excel list of all the users you need to create. Save it under any name, example user_list
Create SQL file with name – grantusr1.sql with the following code
Create user “&1” identified by login;
grant sse_role to “&1”;
grant connect to “&1”;
alter user “&1” default tablespace DATA;
alter user “&1” temporary tablespace TEMP;
Create a shell script and name it. example: create_db_user_list.sh with the following reference code:
for user in `cat user_list`
sqlplus -s login/password@dbhostname << EOF
set define on;
You are now ready to create multiple users within seconds.
Cubastion is among a very small number of specialized Siebel CRM Oracle Gold Partners in SME.