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?