Hi,
My requirement is that i am login from ROOT in a script but when any
command is coming which is logging to sqlplus then i have to run it with normal user as only normal user have permission to connect to sqlplus .

i tried making a script like this :
#! /bin/ksh
su - normal_user
/normal_user/bin/x

where x is the script which is doing all sort of database activity.
but when i run it, it simply comes with normal_user prompt and doing nothing.

Please assist me in this case.

Thanks
rawat

You could try remsh

Hi, Not sure what your script is doing but try a "here-doc"
inside your original script and not run the /bin/x script?
You can pass variables.

ie
su - user_name -c "VAR1=xxx; VAR2=abc; VAR3=${def}<< EOF
Command 1 $VAR1
Command 2 $VAR2
Command 3 $VAR3
etc etc
exit;
EOF
"

su - normal_user << !
/normaluser/bin/x


this works fine i have tried it
....