How to run multiple user connections

[Ron06]

I have different schema like user,hr,payroll in sh script. Right now I'm using connect user/user are hardcord in script. I'm looking how to use variable for each user in sh script instead of specifying indidual connection for each user when running scripts releated to each schema user.

Thanks in advance

 

[Dagon]

There is nothing to stop you putting the username and password into shell variables. You can then connect using something like (in ksh):

export username=SCOTT
export password=TIGER

sqlplus $username/$password@database