Archives of the TeradataForum

Message Posted: Thu, 18 Dec 2003 @ 08:36:36 GMT

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

Glen & All,

That's fine, infact very obvious from the error message itself that the access-right with grant option is needed. My question is why ? If the user could access dbc.tables through the SQL then why not through the macro without access-right with grant option. Is it because the macro which gets created by the user will not have access on dbc.tables as the user does not have access-right with grant option ? Although it sounds a bit weird to me but still that is the only guess I could make out.

Thanks, Vivek.

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