Re: Protecting Passwords In SQL Scripts

On Tue, 19 Aug 1997 13:51:32 -0500, John Hough <q6y_at_ornl.gov> wrote:

The full scenario....
We have written a PC application with an Oracle 7.3 Backend (NT). As part of a client installation the schema is created and a secure user with an encrypted password, which you can do through IDENTIFIED BY VALUES('wibble'). The idea being that when a latter upgrade script is run, the first thing to happen is to change to the secure user. [All this was developed under Sybase]

The secure password will be known at the start of the script and changed at the end.

The real issue is how to write a script with the secure users password in it without it being in straight text - allowing the script to run as someone else.

A sort of Unix 'SU' for Oracle.

Thanks Again

Paul

>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 Wed Aug 20 1997 - 00:00:00 CDT