Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: username/pass --> security issue
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
>
sqlplusw.EXE @c:\jobs\job1.sql
and start job1.sql with
connect user/pass_at_db
-- Regards, Frank van Bortel Top-posting is one way to shut me up...Received on Fri Feb 17 2006 - 15:04:01 CST