Thanks for such a rapid response!
In particular.
Skeate, Scott B <scott.b.skeate_at_lmco.com>
Balaji Chandrasekar <digital_at_astro.ocis.temple.edu>
Salvador Ramirez <sram_at_profc.udec.CL>
Here are the suggestions:
su - oracle << eof
sqldba lmode=t << eof1
connect internal
shutdown (or startup)
exit
eof1
eof
su - <username> -c <script to run>
Original message:
Dear managers,
>
> Is there a way to change your effective user id without using su? Using
> su within a script bounces you out to a prompt.
>
> I need to execute a database shutdown command, as root, but you must be
> oracle for it to run without a password prompt.
>
> This is run from within a Korn shell script.
>
> Thanks in advance
Received on Mon Oct 26 1998 - 18:25:57 NZDT