RE: hide sqlplus pwd
- From: Eugene Pipko <eugene.pipko@xxxxxxxxxxxx>
- To: 'Jared Still' <jkstill@xxxxxxxxx>
- Date: Sat, 31 Oct 2009 14:52:07 -0700
@Jared
Some users have access to the scheduler and can see the password pretty easy.
The user under which tasks are being executed is quite powerful.
I am trying to avoid potential recovery some day.
What I am trying to do is to be able to run our scheduled tasks by running
something like:
Sqlplusw.exe / @c:\jobs\task1.sql;
Perhaps every script that I run will contain a wrapped procedure that would
contain user/pwd and database info.
@Robert
Thanks for the tip. I am not sure, but hope that my users are not that advanced.
@Andre
It sounds that what I am trying to do and what you're talking about is in the:
http://download.oracle.com/docs/cd/B10501_01/win.920/a95492.pdf
Is that right?
Regards,
Eugene Pipko
Seattle Pacific Industries
office: 253.872.5243
cell: 206.304.7726
P Please consider the environment before printing this e-mail.
From: Jared Still [mailto:jkstill@xxxxxxxxx]
Sent: Friday, October 30, 2009 5:50 PM
To: Eugene Pipko
Cc: oracle-l List
Subject: Re: hide sqlplus pwd
On Fri, Oct 30, 2009 at 3:22 PM, Eugene Pipko
<eugene.pipko@xxxxxxxxxxxx<mailto: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:
