Quote:
Originally Posted by
SekhaReddy
Can anyone suggest me how to decrypt the password from the file and it needs to be connected to the repository as well. And also provide me the sample script file to understand better.
Thanks in advance....
Quote:
While script file is running in informatica it shouldnot prompt.
We get threads asking for this again, and again.
Encryption does not work that way.
Period. No ifs, ands, or buts. It just doesn't. You are asking for a logical contradiction -- if the script must output the unencrypted password without user intervention, it by definition contains complete instructions for retrieving the password. This is one big reason why embedding passwords in scripts is a bad habit.
If you want to conceal the password from the user,
chmod is the protection you need. Prevent them from reading the script, or put it in another file which they cannot read themselves. Or, arrange a way that doesn't require a password.