Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Thu, 30 Dec 2004 @ 09:47:31 GMT


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


Subj:   Re: Does Teradata support the concept of a "trusted connection"
 
From:   Mike Felts

I don't know the answer to your question, but I'd like to suggest an alternative solution:

Define seperate ETL usernames for Dev, Test, and Prod. The Dev ETL username would have select/insert/update/etc access to Dev but only select from Prod. The other two ETL usernames would be set up similarly. Setup logon files on the environments so that the Dev environment uses the Dev ETL username only, etc. This way you can be assured that the Dev ETL Environment can only perform selects from non-Dev databases.

Possibly not as seemless as trusted connections and using only one username, but I would think it would be easier to implement and less error- prone.


Mike



     
  <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: 28 Jun 2020