Oracle-L: RE: SUPPRESS SQL STATEMENTS

From: Jamadagni, Rajendra <Rajendra.Jamadagni_at_espn.com>
Date: Thu, 16 Oct 2003 10:19:48 -0800
Message-ID: <F001.005D3654.20031016101948@fatcity.com>

I usually do

echo passwd | sqlplus -s user_at_db

Raj

Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !

-----Original Message-----
lto:johan_sr_at_yahoo.com]
Sent: Thursday, October 16, 2003 2:09 PM To: Multiple recipients of list ORACLE-L

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 environment variables

ORACLE_BASE=/opt/oracle
JOBDATE=`date '+%Y%m%d'`; export JOBDATE; JOBTIME=`date '+%H%M'`; export JOBTIME;
sqlplus -S << EOF
username/pw_at_instancename
set echo off
rest of script
EOF Jared.Still_at_radisys.com wrote:

what are the limitations?

other than ps commands that can read past a 3k command line

"Norris, Gregory T [ITS]" <gregory.t.norris_at_mail.sprint.com> Sent by: ml-errors_at_fatcity.com

10/15/2003 12:34 PM
Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> 
        cc:         
        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-----
.com [mailto:Jared.Still_at_radisys.com]
Sent: Wednesday, October 15, 2003 2:09 PM To: Multiple recipients of list ORACLE-L SQL STATEMENTS not a pr! oblem on most *nix if you use hide.c

http://www.cybcon.com/~jkstill/util/zips/hide.tgz

Jared

"Norris, Gregory T [ITS]" <gregory.t.norris_at_mail.sprint.com> Sent by: ml-errors_at_fatcity.com

10/15/2003 06:49 AM
Please respond to ORACLE-L

        
       To:        Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> 
       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 while you're inside sqlplus. Run it from outside: sqlp! lus un/pw @your-script
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Norris, Gregory T [ITS]
INET: gregory.t.norris_at_mail.sprint.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.

**************************************************************************************5

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Jamadagni, Rajendra
INET: Rajendra.Jamadagni_at_espn.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------