Exclude columns from Table in SQL Server with limmited read rights

Anonymous — Tue, 15 Aug 2017 15:27:00 GMT

I try to fetch data from a Table in an SQL Server where I have limmited read access for specific columns.

If I try to see the table I get the follwoing error

"DataSource.Error: Microsoft SQL: The SELECT permission was denied on the column 'XYZ' of the object 'tableName', database 'DBName', schema 'schemaName'."

Because I do not have access to read the column 'XYZ'. Is there anyway to exclude columns?

The equivalent SQL Query would be:

SELECT [ABC], [DEF]
FROM [DBName].[schemaName].[tableName]

instead of the follwoing two queries that wold not work because I do not have read access for a specific column.

SELECT *

FROM [DBName].[schemaName].[tableName]

SELECT [ABC], [DEF], [XYZ]

FROM [DBName].[schemaName].[tableName]

Re: Exclude columns from Table in SQL Server with limmited read rights

Greg_Deckler — Tue, 15 Aug 2017 17:04:24 GMT

When connecting to the SQL Server data source, click on the Advanced link and then you can enter a specific SQL query like the first one that you listed.

topic Exclude columns from Table in SQL Server with limmited read rights in Developer

Exclude columns from Table in SQL Server with limmited read rights

Re: Exclude columns from Table in SQL Server with limmited read rights