Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: username/pass --> security issue
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 DBAReceived on Fri Feb 17 2006 - 14:21:01 CST