From: | Fernando Luna <Fernando(dot)Luna(at)Tideworks(dot)com> |
---|---|
To: | "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>, "'pgsql-odbc(at)postgresql(dot)org'" <pgsql-odbc(at)postgresql(dot)org> |
Subject: | Re: Question regarding accessing only tables to which the user has access |
Date: | 2016-03-29 03:27:30 |
Message-ID: | 479BB3381124DA41AC6539F10BBF788E2212EB0F@LWEXMB4.usa.int |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Hi Takayuki:
Thank you so much for your quick reply. I'll try this in the morning and let you know how it goes. Additionally I'll pass on your comments to the Tableau folks.
Have a great day!
Fernando Luna
_______________________________________
From: Tsunakawa, Takayuki [tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com]
Sent: Monday, March 28, 2016 8:10 PM
To: Fernando Luna; 'pgsql-odbc(at)postgresql(dot)org'
Subject: 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
From | Date | Subject | |
---|---|---|---|
Next Message | Inoue, Hiroshi | 2016-03-29 03:49:09 | Re: Question regarding accessing only tables to which the user has access |
Previous Message | Tsunakawa, Takayuki | 2016-03-29 03:10:30 | Re: Question regarding accessing only tables to which the user has access |