Archives of the TeradataForum

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

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

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