On 17 Feb 2006 11:06:53 -0800, epipko@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@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