Re: hide sqlplus pwd
- From: Robert Freeman <robertgfreeman@xxxxxxxxx>
- To: jkstill@xxxxxxxxx, eugene.pipko@xxxxxxxxxxxx
- Date: Sat, 31 Oct 2009 08:35:10 -0700 (PDT)
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!
Author:
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
Blog: http://robertgfreeman.blogspot.com
________________________________
From: Jared Still <jkstill@xxxxxxxxx>
To: eugene.pipko@xxxxxxxxxxxx
Cc: oracle-l List <oracle-l@xxxxxxxxxxxxx>
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 <eugene.pipko@xxxxxxxxxxxx> wrote:
>
>
>
>
>
>
>
>
>
>
>>
>>
>We’re running Oracle 8,9,10
>on Windows. Third party scheduler program executes scripts against Oracle as:
>sqlplusw.exe user/pwd@db
>@c:\jobs\task1.sql
>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: http://jkstill.blogspot.com
Home Page: http://jaredstill.com
Other related posts:
