Permission Error Using 'Script Table As' Option in SQL Server Management Studio via ODBC

 

The customer will encounter the permission error when using Microsoft SQL Server Management Studio with ODBC by following any of the two scenarios.

• The customer created a linked server to an ODBC data source using Microsoft OLEDB provider for ODBC drivers in SQL Server Management Studio.
• The customer uses the 'Script Table as' option on one of the tables on the linked server in the SQL Server Management Studio.  

Following any of the two scenarios will result to an error message.

• [LinkedServer].[DatabaseName].[dbo].[TableName] contains no columns that can be selected orthe current user does not have any permissions on that object. 

The cause of this error is the limitation of the Microsoft product with MSDASQL provider. Microsoft has confirmed that this is a problem with their Microsoft product and using a different application other than the SQL Server Management Studio will not throw the error.