Re: hide sqlplus pwd

From: Robert Freeman <>
Date: Sat, 31 Oct 2009 08:35:10 -0700 (PDT)
Message-ID: <>

Actually, if you are running on WIN XP there is a command called tasklist.exe. This command, if run using the /v switch would show sqlplus.exe AND any username/password entered at the command line. Here is an example:

C:\Documents and Settings\Robert>tasklist /v |find "Command Prompt"
cmd.exe                    10128 Console                 0      2,672 K Running         ROBERTSDELLXPS\Robert
            0:00:00 Command Prompt - sqlplus sys/robert as sysdba

 Robert G. Freeman
Oracle ACE
Ask me about on-site Oracle Training! RMAN, DBA, Tuning, you name it!
Oracle Database 11g RMAN Backup and Recovery (Oracle Press) - ON IT'S WAY SOON!
OCP: Oracle Database 11g Administrator Certified Professional Study Guide (Sybex)
Oracle Database 11g New Features (Oracle Press)
Oracle Database 10g New Features (Oracle Press)
Other various titles

From: Jared Still <>
Cc: oracle-l List <>
Sent: Fri, October 30, 2009 6:49:41 PM
Subject: Re: hide sqlplus pwd

On Fri, Oct 30, 2009 at 3:22 PM, Eugene Pipko <> wrote:

>We’re running Oracle 8,9,10
>on Windows. Third party scheduler program executes scripts against Oracle as:
>sqlplusw.exe user/pwd_at_db
>What are the ways of hiding
>user/pwd from curious eyes?

Some clarification on what you are trying to hide might be useful.

Are you trying to prevent the passwords from appearing in the scheduled scripts?

Or the log files?

Or something else?

As this is windows, it doesn't really have the ps command available to show
the password.  Even if ps is available, I don't think it shows the password.

IAC, more info is needed.

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Oracle Blog:
Home Page:
Received on Sat Oct 31 2009 - 10:35:10 CDT

Original text of this message