See use of UNIX "here" document
e.g.
#!/bin/ksh
sqlplus madhu@databasename/gossip123<<<b>STR</b>
create user kukku
identified by kukku123
default tablespace USERS
temporary tablespace TEMP
quota unlimited on USERS
quota 10M on TEMP
quota 0M on SYSTEM;
grant create session, resource
to kukku;
STR
if you have lots of users to be created on many databases, then put the users and their passwords ina file and give the aboe command in a loop which will repeat around the contents of the file containig databases and usernames and passwords. For simplicity you can take default passwords of users as <username>123 .
I think you want this only?
#!/bin/ksh
for dbname in `cat dblist.txt`
do
for user in `cat userlist.txt`
do
sqlplus admin@$dbname/adminpasswd<<<b>STR</b>
create user $user
identified by $user123
default tablespace USERS
temporary tablespace TEMP
quota unlimited on USERS
quota 10M on TEMP
quota 0M on SYSTEM;
STR
done
done
I have not tested it. But it will be like this.
] 
Blog
Search
Help
Members
Register
Login
Home
