Re: Need advice on encrypting the password

From: Shastry(DBA) <"Shastry>
Date: Thu, 28 Apr 2016 13:31:17 -0500
Message-ID: <CAFQkUXRCQXx4wa-7Dq1NYiBC60Q0xreHzbViU_ik5FzSpkGgyA_at_mail.gmail.com>



Thanks Sreejith. I am also looking for ways to store the password within the database and hash it. Will consolidate and publish once I succeed with this approach.

Regards,
Shastry

On Wed, Apr 27, 2016 at 8:41 PM, Sreejith Nair <sreejithsna_at_gmail.com> wrote:

> You can use secure external password store as advised earlier. This is
> free , easy and clean solution
>
>
> http://docs.oracle.com/cd/B19306_01/network.102/b14266/cnctslsh.htm#CBHEHGCE
>
> Thanks
> Sreejith
>
> On 27 Apr 2016, 8:14 PM +0530, Shastry(DBA) <shastry17_at_gmail.com>, wrote:
>
> Hi All,
>
> Thank you for your response. Basically we are trying to achieve Oracle
> Apps Cloning through shell script which requires admin passwords like
> weblogic sysadmin and database passwords. Sorry for my delay in response as
> I fell sick. Please advice.
>
> Regards
> Shastry
>
> On Wednesday, April 27, 2016, Marcos Antonio Colmenares Hayek <
> marcoscolmen_at_banesco.com> wrote:
>
>> Good Day Shastry,
>>
>>
>> https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:142212348066
>>
>> Hope this helps.
>>
>>
>> Best Regards,
>>
>> *Marcos Colmenares H.*
>> Especialista de Base de Datos II
>> Gerencia de Base de Datos
>> Vp. Sopt. Oper. & Mtto. de Infraestructura
>> Teléfono (212) 501 - 8933
>> Red interna 502 - 8933
>> Ciudad Banesco P1 A 18-06
>>
>> In this day and age, most servers are dedicated to the Oracle database.
>> As a consequence, it really makes no sense to refuse root access from a
>> reasonably knowledgeable Oracle DBA. The data in the database is the only
>> item that is important to security and the financial health of the company,
>> so there is nothing the root user can do that is more important than the
>> oracle user. - Andrew Kerber
>>
>> 2016-04-26 12:18 GMT-04:30 Shastry(DBA) <shastry17_at_gmail.com>:
>>
>>> Hi Gurus,
>>>
>>> We have automated cloning tool which runs mainly as shell script. Our
>>> passwords are stored on a file which is required while cloning is in
>>> progress, the logic is to have both PROD and NONPROD credentials are stored
>>> in the flat file which will be read by the shell script. I want to know if
>>> there is a way to decrypt and encrypt back again once the clone process is
>>> done or is there is a better way to manage the script in storing passwords?
>>> Kindly share your advice.
>>>
>>> Thanks,
>>> Shankar
>>>
>>
>>
>>
>>

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Apr 28 2016 - 20:31:17 CEST

Original text of this message