Archives of the TeradataForum

Message Posted: Wed, 26 Nov 2008 @ 13:11:41 GMT

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

Rajesh,

This error refers to the database to database grant between your view database and table database. To resolve this you need to issue:

GRANT SELECT ON <database containing tables> TO <database containing views> WITH GRANT OPTION;

This needs to be done for each database referenced in the view.

Regards,

Rob

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