Archives of the TeradataForum

Message Posted: Thu, 17 Dec 2009 @ 22:37:43 GMT

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

SQL Assistant itself does not directly fetch the object names. It calls an ODBC (or .Net) function that returns the list of tables/views in whatever manner the developer of that ODBC driver decided to use.

For Teradata, the table/view names will be retreived from one of the DBC views. Depending on your Teradata.Net or ODBC DSN settings it may use either dbc.Tables or DBC.TablesX. (or maybe TablesV or TablesVX)

You will therefore need the Select right on one of these views.

Mike Dempsey
Teradata Client Tools

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