Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 16 Mar 2009 @ 17:26:38 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: BTEQ question: How to handle login/password
From:   Mohommod.Khan

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 :)

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016