Archives of the TeradataForum

Message Posted: Fri, 02 Dec 2005 @ 10:33:30 GMT

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

I think it's doing just what it's paid to do :) ... and not a bug although I would love to see this feature implemented in one of the future releases.

This has a lot to do with the way the PE processing works.

When PE parser gets an SQL request, then if the request is not already in the request cache, then the syntax of the SQL request is verified along with any other additional internal object identifier resolutions, after which the access rights are verified and then passed on to the optimizer.

So as you can see it goes to the optimizer only after going through the access rights verification process. Though I am not sure why it's that way. But my guess is that because it would be a waste of processing time if the optimizer already did the work and then teradata figured out that the user did not have sufficient access rights.

The catch though is that when we innocently wants just the explain information, PE still turns us down. and that's because access rights are verified before reaching the optimizer stage. Probably they can come up with an exception for explain statements in the future if that's possible ... that would be nice.

Joseph Vinish D'silva

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