Re: Question regarding accessing only tables to which the user has access

Hello, Fernando,

Try setting the extra option parameter in either of the following ways:

* If you use the connection string, add "AB=10".

* If you configure the data source using the ODBC Administrator, enter "10" in the "Extra Opts" text box in advanced settings page 2.

BTW, maybe Tableau should provide the option to list the tables on which the user has SELECT privilege. Tableau should do so by first calling SQLGetInfo(SQL_ACCESSIBLE_TABLES), and then calling SQLTablePrivileges() if SQLGetInfo() returns "N". Tableau perhaps calls SQLTables() instead. As the reference page describes, it is driver-dependent whether SQLTables() returns only accessible tables or all tables.

SQLTables Function
https://msdn.microsoft.com/en-us/library/ms711831(v=vs.85).aspx
--------------------------------------------------
SQLTables lists all tables in the requested range. A user may or may not have SELECT privileges to any of these tables. To check accessibility, an application can:

Call SQLGetInfo and check the SQL_ACCESSIBLE_TABLES information type.

Call SQLTablePrivileges to check the privileges for each table.
--------------------------------------------------

Regards
Takayuki Tsunakawa