to run sql as superuser - Shell Programming and Scripting

#1 (**permalink**) 04-28-2008

hi All,

In my script I want to run some drop and select statements in the same host as a different user.I am inputting password for the superuser from the user who will be executing the script.

ie ,

Quote:

#!/bin/ksh
echo " \n\n\t Enter the superuser's password:\c"
read pass

I would be greatfull to you experts if you could suggest me how to proceed.