Archives of the TeradataForum

Message Posted: Thu, 03 Sep 2009 @ 20:55:50 GMT

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

When you created the macro it implicitly recorded the database to use, which was your ID. When you ran as someone else, it tried to use your ID to create a volatile table, which it could not do since you were signed on as someone else. This is akin to doing a SELECT * in a macro or view and then changing the underlining table. You could break the macro or view if you remove a column in the table.

Hope this helps.

John D. Elliott,Jr.
Teradata Master, Information System Specialist
Business Data Management, USPS - Raleigh, NC

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