ODBC access from Excel to Teradata, table restriction

Connectivity
Enthusiast

ODBC access from Excel to Teradata, table restriction

I have some problems accessing Teradata from EXCEL with a ODBC driver.

The Teradata database BASE_A, has user access restriction set on the base itself.

Here I can setup the ODBC driver so that I get access to BASE_A from Excel.

But I have another database BASE_B here the restriction is set on the tables inside the database, so that a user has access to BASE_B.Table_1, and BASE_B.Table_2, but not the BASE_B.Table_3, BASE_B.Table_4 and BASE_B.Table_5.

Is there a way to setup the ODBC driver so that it will allow access for such a user to the BASE_B?

Br

Peter Schwennesen

Tags (2)