Re: Need advice on encrypting the password
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Tue, 26 Apr 2016 12:52:39 -0400
Message-ID: <571F9CD7.2010902_at_gmail.com>
On 04/26/2016 12:48 PM, Shastry(DBA) wrote:
> 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
You can use wallets. Wallet will enable you to do sqlplus /_at_tnsdesc as sysdba, as long as you have the proper certificate installed on the server. Oracle has actually done an excellent thing with wallets: they are secure, convenient and easy to use.
Regards
Date: Tue, 26 Apr 2016 12:52:39 -0400
Message-ID: <571F9CD7.2010902_at_gmail.com>
On 04/26/2016 12:48 PM, Shastry(DBA) wrote:
> 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
You can use wallets. Wallet will enable you to do sqlplus /_at_tnsdesc as sysdba, as long as you have the proper certificate installed on the server. Oracle has actually done an excellent thing with wallets: they are secure, convenient and easy to use.
Regards
-- Mladen Gogala Oracle DBA http://mgogala.freehostia.com -- http://www.freelists.org/webpage/oracle-lReceived on Tue Apr 26 2016 - 18:52:39 CEST