I run the following script, and the -S option solved the problem I had (I even had the line # out in the script and re-invoked it).
If the username/pw is on a separate line as shown below, the ps command does not display the userid/pw info.
# Set environment variables#!/bin/ksh
# Set local
is an art !
-Original Message-From: Johan Muller
[mailto:[EMAIL PROTECTED]Sent: Thursday, October 16, 2003 2:09
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
SUPPRESS SQL STATEMENTS
I run the following script, and the -S option solved the problem I had (I
even had
On *nix systems, the username/password information will be visible to all via the ps
command. Not good.
-Original Message-
Sent: Tuesday, October 14, 2003 11:09 AM
To: Multiple recipients of list ORACLE-L
Don't run the script while you're inside sqlplus. Run it from outside:
sqlplus
]
cc:
Subject:RE: SUPPRESS SQL STATEMENTS
On *nix systems, the username/password information will be visible to all via the ps command. Not good.
-Original Message-
Sent: Tuesday, October 14, 2003 11:09 AM
To: Multiple recipients of list ORACLE-L
Don't run the script
True,
but last I checked it had a number of limitations...it's basicallya
band-aid,while the patient is hemorrhaging.
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]Sent: Wednesday, October 15, 2003
2:09 PMTo: Multiple recipients of list ORACLE-LSubject:
:
Subject:RE: SUPPRESS SQL STATEMENTS
True, but last I checked it had a number of limitations... it's basically a band-aid, while the patient is hemorrhaging.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 15, 2003 2:09 PM
To: Multiple
set head off message off feedback off echo off
_
David Kurtz
Go-Faster Consultancy Ltd.
tel: +44 (0)7771 760660
fax: +44 (0)7092 348865
mailto:[EMAIL PROTECTED]
web: www.go-faster.co.uk
PeopleSoft DBA Forum: http://groups.yahoo.com/group/psftdba
-Original Message-
Don't run the script while you're inside sqlplus. Run it from outside:
sqlplus un/pw @your-script
-Original Message-
Sent: Monday, October 13, 2003 12:49 PM
To: Multiple recipients of list ORACLE-L
A script dumps out table info. (sqlplus on aix 4.3.3 and oracle 8.1.7).
I cannot
The script is run from a cron job with a ksh script calling the sql from outside
sqlplus.
I've solved the problem by using sed to cull the offensive lines, but I should be able
to use
sqlplus formatting statements to give the correct results. I did include message off
(from a
previous email),
recipients of list ORACLE-L [EMAIL PROTECTED]
cc
Subject
RE: SUPPRESS SQL STATEMENTS
Don't run the script while you're inside sqlplus. Run it from outside:
sqlplus un/pw @your-script
-Original Message-
Sent: Monday, October 13, 2003 12:49 PM
To: Multiple recipients of list ORACLE-L
Use the silent option -S in sqlplus
-Original Message-
Sent: Tuesday, October 14, 2003 12:29 PM
To: Multiple recipients of list ORACLE-L
The script is run from a cron job with a ksh script calling the sql from
outside sqlplus.
I've solved the problem by using sed to cull the offensive
-Original Message-
Johan Muller
A script dumps out table info. (sqlplus on aix 4.3.3 and
oracle 8.1.7).
I cannot suppress the PROMPT@path/scriptname and
PROMPT spool off statements from the report output.
The script contains both set heading off and set feedback
off as
Start the script from another script?
Johan Muller wrote:
A script dumps out table info. (sqlplus on aix 4.3.3 and oracle 8.1.7).
I cannot suppress the PROMPT@path/scriptname and
PROMPT spool off statements from the report output.
The script contains both set heading off and set feedback
13 matches
Mail list logo