Shell Programming and Scripting

Day before yesterday,I got the success creating a shell script using expect tool and now it is running successfully on the server.
Now I want to make some changes in paswwordchanger.sh as you can see it can handle only one user i.e dbaguest and not other user.So I am thinking the logic how I can implement.
Corrent script will work in following order:

One ssh.csv file will be generated using below query which needs to be called inside passwordchanger.sh

Code:

SET FEEDBACK OFF
SET LINESIZE 80
SET PAGESIZE 0
SET NEWPAGE 0
SET SPACE 0
SET VERIFY OFF
SET HEADING OFF
SET MARKUP HTML OFF
SPOOL ssh.csv
Select username||','||ipaddr||','||password  from table where boatid='xyz' and auth='YES';
SPOOL OFF
exit;

(1) It will accept newpassword for dbaguest and it will be stored in a variable i.e paswd.
(2) It will generate a file ssh.csv using boatid where authentication for the user is true.
(3) It will read each line in ssh.csv file and will connect to the host and will change the password with new password what we are passing in step1.
(4) If it fails then it will write it into a log file with ipaddress.

Here I want to make it for other user as well suppose oracle user is there for which I have access but directly I can not login to the server using spawn ssh oracle@ipaddr.
It must login first dbaguest and then su – oracle or other user and then change the password.
For above task I have to play with username variable in passwordchanger.sh with if condition or using case statement.
please suggest me correct line where I can modify and what can be modified.
I appreciate your help.Its a bit urgent.

I am listing my script below which is running successfully:--

Moderator's Comments:

Removed excessive formatting (is it really necessary to format each line on it's own?), added code tags, added meaningful title. Due to multiple cases of this, this user has been temporarily set to "Read Only"