Batch User Password Management

General covers Articles, Reference documentation, FAQs, Downloads and Blogs that do not belong to a specific subject area. General-purpose Articles about everything and anything

Batch User Password Management

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.