SQLTablePrivileges
The Microsoft® SQL Server™ ODBC driver uses the sp_table_privileges catalog stored procedure to satisfy table privilege data requests using SQLTablePrivileges.
SQLTablePrivileges can be executed on a static cursor. An attempt to execute SQLTablePrivileges on an updatable (keyset-driven or dynamic) returns SQL_SUCCESS_WITH_INFO indicating the cursor type has been changed.
The SQL Server ODBC driver supports reporting information for tables on linked servers by accepting a two-part name for the CatalogName parameter: Linked_Server_Name.Catalog_Name.