Re: Protecting Passwords In SQL Scripts

From: John Hough <q6y_at_ornl.gov>
Date: 1997/08/19
Message-ID: <33F9EB34.50C5@ornl.gov>#1/1

Paul:

I am not sure what problem you are trying to solve. If you have crete for your users ops$ accounts then no password is needed the users can login as

sqlplus / @junk.sql

as far as i know you cannot pass a encrypted password to oracle for it to decrypt and use. If you would give a little more information including OS, Oracle Version and examples of what the problem is. I will try to provide more data.

Thanks,

John Hough

Paul Taylor wrote:
>
> Is it possible to connect to a database through the use of an
> encrypted password ?
>
> I'd like to be able to run a script as a non DBA user, allowing the
> script to connect as a special user without disclosing the password.
>
> Thanks
>
> Paul Taylor
Received on Tue Aug 19 1997 - 00:00:00 CDT