Archives of the TeradataForum

Message Posted: Wed, 01 Dec 2004 @ 20:24:09 GMT

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

Michael,

I'm confused by your syntax...I thought a given query logging rule statement could only work for a particular user or account or for 'all.' It looks like you are trying to set a rule for a user and an account at the same time.

What does your DBQLRules table looks like?

Also, it may be that user 'Y's info hasn't been flushed to disk yet (each Node has its own DBQL cache, I think), while User 'X's info (on another node) has been flushed to disk.

Hope this helps,

Clay

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