Hi,
Could you give some more details on which credentials are stored?
Are these database credentials used to login to the database or os
credentials? Or maybe passwords required for recreating database links
or users?
You could use oracle wallets to store db credentials to be able to login
to a database without needing a password (but that means that you need
to protect your os user even more).
For OS credentials, sudo might be an option.
Database links and users became more difficult since Oracle is no longer
accepting the "identified by values clause" (at least not for db links).
Best option there might be to change the script to use datapump....
Kind regards,
Freek
On di, 2016-04-26 at 11:48 -0500, 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
