Jared:
How do you do this for an export cron job ?
Thanks
David Jones
ITResource
-Original Message-
Sent: Monday, February 24, 2003 2:51 PM
To: Multiple recipients of list ORACLE-L
The 'hide.c' program can be implemented and compiled to prevent
parameters from appearing to ps. I belie
sqlplus /nolog shutdown
Thanks in advance,
David
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Nguyen, David M
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- M
gt; Subject: RE: Embeded password in script
>
>
> Actually, this would still display the password in the output
> of "ps -ef"
> because the "$syspw" environment variable is resolved before
> handing it to
> sqlplus.
>
> Try "sqlp
You can have username/password in the first line of the sqlplus script.
sqlplus @your-script.sql
Your-script.sql will have id/pw in the first line.
Regards,
Waleed
-Original Message-
Sent: Monday, February 24, 2003 3:54 PM
To: Multiple recipients of list ORACLE-L
I have been tasked t
Actually, this would still display the password in the output of "ps -ef"
because the "$syspw" environment variable is resolved before handing it to
sqlplus.
Try "sqlplus dbimpl/$syspw" and then a "ps -ef"...
Rich
Rich JesseSystem/Database Administrator
[EMAIL PROTECTED]
Title: RE: Embeded password in script
Thank you, Jared. I have the book you wrote and will look into it.
Regards,
David
-Original Message-
From: Jared Still [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 24, 2003 4:51 PM
To: Multiple recipients of list ORACLE-L
Subject: Re
$cd ${STUFF}/log
$cat ../parms/dbimpl.Connect
connect dbimpl/[EMAIL PROTECTED] as sysdba
-- Optionally, could have sql*plus environment modifications
$cat ../sql/demo.sql
@../parms/&1..Connect
-- SQL commands
shutdown
exit
$sqlplus /nolog @../sql/demo.sql dbimpl
The unix permissions on the parms di
The 'hide.c' program can be implemented and compiled to prevent
parameters from appearing to ps. I believe it still works properly on
most flavors of unix.
For the "Perl for Oracle DBA's" book we wrote one utililty that I had
wanted for some time, a password database.
For jobs that I plan to r
i'll take the first one...
on UNIX you could use a secret hidden file with appropriate permissions
where each line has the format ORACLE_SID:USER:password
then use awk to parse the file for the line with the correct $ORACLE_SID and
$USER, and set an environment variable to the password string. T
Title: RE: Embeded password in script
cat > pwfile
syspw=blah
export syspw
^D
chmod 700 pwfile
Unix Prompt> . pwfile
Unix Prompt> sqlplus dbimpl/$syspw @your_script_here
Raj
-
Rajendra dot Jamadagni at espn dot com
David
You could change the read permission on the script so nobody can read it.
A larger issue is how to prevent other users from seeing the password while
your process is executing. Connor McDonald who participates on this list has
some ideas at:
http://www.jlcomp.demon.co.uk/faq/hide_password.
Sent by: Subject: Embeded password in
script
[EMAIL PROTECTED]
02/24/2003 12:54
PM
Please respond to
ORACLE-L
sqlplus -s < -Original Message-
> From: Nguyen, David M [mailto:[EMAIL PROTECTED]
> Sent: Monday, February 24, 2003 3:54 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Embeded password in script
>
>
> I have been tasked to write a script to run SQL. I
I have been tasked to write a script to run SQL. I don't want a password
field to be shown in the script. Does someone have run into this and have a
better idea? For example, I have following line in my script.
Sqlplus dbimpl/password @SQLscript.sql
Also, from command line we go through follo
14 matches
Mail list logo
