Archives of the TeradataForum

Message Posted: Fri, 25 Mar 2005 @ 22:03:00 GMT

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

What we do is to create logon files that contain the .logon tdpid/userid,password; line in them. These files are given permissions such that developers cannot read/execute them in test and production, but can in development. In the fastload/multiload/bteq/whatever you do a .RUN FILE={logon file} to logon.

This means that your logon information is centralized to one location so it can be changed if need be, and as well developers don't have access to run scripts or even know the logon information for environments where they shouldn't.

Mike

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