Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: username/pass --> security issue

Re: username/pass --> security issue

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 17 Feb 2006 21:21:01 +0100
Message-ID: <gvbcv1hds5tlf5reilf3bi9c9kjd5q47t9@4ax.com>


On 17 Feb 2006 11:06:53 -0800, epipko_at_gmail.com wrote:

>Hi all,
>We created a user in Oracle 9i and use it to run nightly processing via
>scheduler (3rd party) by executing .bat files (windows 2003).
>Works fine, but there is one little thing: the user/pass is visible in
>the string.
>Here is the example:
>.bat
>-----------------
>sqlplusw.EXE USER/PASS_at_DB @c:\jobs\job1.sql
>-----------------
>
>What do I need to do to hide the password?
>
>Thanks,
>Eugene

either convert to a stored procedure and schedule through dbms_jobs, or start using O/S authenticated accounts, so you can use sqlplus /@db @....

--
Sybrand Bakker, Senior Oracle DBA
Received on Fri Feb 17 2006 - 14:21:01 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US