Anonymous Staff asked 2 years ago
Title : How to create multiple user in Siebel DB using shell script.

Question :

How to create multiple user in Siebel DB using shell script.

1 Answers
anubhavanubhav Staff answered 2 years ago

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`
do
sqlplus -s login/password@dbhostname << EOF
set define on;
@grantusr1.sql $user
EOF
done
 
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.