Archives of the TeradataForum
Message Posted: Mon, 16 Mar 2009 @ 17:26:38 GMT
How about creating specific directory where you save the login info? Then you can cat dynamically the ddl to the login info and then send the file to a temp folder where you actually run it?
Just have an ETL group created where you grant access to the login info + temp etc and then execute that.
Ensure to clear the temp folder after you are done running your job or incase there is an error.
Remember Log will never display your password.
Now that is the easiest way to secure the password. You can be fancy if you want, by encrypting your login file and then decrypt using some code when you dynamically execute the code. Hope this helps.
Now from your original question, if you don't type/pass the password on script, it will prompt you for that. If that is what you want.
Have fun :)
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|