to run sql as superuser

#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.

era · #2 (**permalink**) 04-28-2008

Imagine big bold letters here: Don't Do That.

Simply run su - user -c "commands" and su will take care of prompting for the password.

Reading the root password in a userspace script is not recommended.

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

Hi ,

Thanks a lot for your reply.
Can you pls site an example also?
I tried reproducing the command but failed.
I was actually trying...

Code:

su - user1 -c "echo 'user123'"
sleep 10
sqlplus "/as systemdba"
select name from v$database; <<+ENDOFSQL+
exit
+ENDOFSQL+
exit

The prompt for password came and the sleep command or echo command is not executed after wards.
The password expected is not root password.

era · #4 (**permalink**) 04-28-2008

You said "superuser password", I assumed root password.

The idea would be 'su - user1 "commands to connect to sql"' -- if it's a long script then just put that in a file and execute that file.

Cameron · #5 (**permalink**) 04-28-2008

Like ...

su - user -c "myscript.sh"

And in myscript.sh you'd have something like (perhaps) ...

...
sqlplus /as sysdba @myscript.sql
...

And lastly, in myscript.sql you'd have (or similar) ...

select name from v$database ;

Anyways, hope that helps some

Cheers,
Cameron

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
SuperUser	maconte	UNIX for Dummies Questions & Answers	0	03-19-2007 01:36 PM
runing a script as superuser	bcheaib	UNIX for Dummies Questions & Answers	2	07-07-2004 01:24 AM
how to check my hard disk is below 10%, and then send mail to superuser	foong	Shell Programming and Scripting	3	08-07-2003 11:28 AM
No user able to login except root(superuser)	konda	UNIX for Advanced & Expert Users	2	06-25-2002 12:19 PM
superuser password change	apalex	UNIX for Dummies Questions & Answers	4	04-12-2002 11:38 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread: