Archives of the TeradataForum

Message Posted: Wed, 09 Aug 2006 @ 20:45:47 GMT

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

I don't know of any way to restrict a user from logging on more than x sessions. Especially for utilities like mload, fastload and fastexport. However, you can use Dynamic Workload manager to restrict a user or group of users from running x amount of queries or sessions at the same time. This tool used to be called Dynamic Query Manager. You can even make this limit based on Type of SQL (DML, DDL and SQL), Time of day and PLAN estimates.

There is a lot that I am leaving off. Please check out the tool documentation.

Thanks,

Bob Diehl

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