Archives of the TeradataForum
Message Posted: Thu, 30 Dec 2004 @ 09:47:31 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|