My ETL jobs consist on mix of Utilities involving, BTeq, Informatica,Loader utilities. etc which runs from a UNIX platform... And I use a batch user to perform these activites.
I was able to encrypt to password for using in Informatica tool. But for using in Bteq tool we still need to store the password in some logon file . This creates a security risk.
I've explored the possiblities of using the TD Wallet, but it is down to one particular user. We might run scripts from multiple Unix users ( say from multiple scheduling tools).. So TD Wallet becomes unusable in those cases.
Please suggest a optimal of protecting passwords to avoid passwords falling into wrong hands.