View Single Post

   
  #5 (permalink)  
Old 02-25-2008, 02:25 AM
Frank van Bortel
 
Posts: n/a
Default Re: username/pass --> security issue

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
>


sqlplusw.EXE @c:\jobs\job1.sql
and start job1.sql with
connect user/pass@db
--
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
Reply With Quote