Archives of the TeradataForum

Message Posted: Fri, 27 Aug 2004 @ 11:51:15 GMT

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

Hey Al...

I know your level of expertise is very high so I categorize this under the "Un-Explainable"

I would suggest that you recreate the view as the same user that created the other views that are working fine. If the view as already been created by the same user as the other views that are working, well so what.. Replace the offending view anyway.

If this does not work, try creating another view in another database and point it to the offending table using a select with grant option from the view database to DBTEST. We are trying to see if we can find the pattern.

If this does not work, then click you heels three times and repeat the phrase "There's no place like home, there's no place like home"

Best Regards

Chris Coffing
AFKS O&M Lead Teradata DBA
Certified Teradata Master

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