Archives of the TeradataForum

Message Posted: Thu, 17 Jul 2003 @ 14:24:40 GMT

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

Assuming you are just trying to control MSI users then what you have seems to be the best. Throttle user access from within MSI.

Other ideas:

Use priority scheduler with different partitions defined for ETL and MSI user groups.

Have the views that MSI access control which rows are returned. Where Load_Dt

-or-

Where Load_Id <= (select max(Load_Id) from Load_Statistics where Load_Status='Complete')

Jim

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