How do I grant Read Access to FILESTream data in a table but not grant SELECT access?

by Michael Ward   Last Updated October 19, 2017 21:06 PM

Problem:

I want users to be able to download data stored in a table that contains a FILESTREAM column. Each file is typically 200 to 500 MBytes. I however do not want to grant the user SELECT access (specifically SELECT *) to the table. I was able to create a stored procedure that provides the Path / Transaction Context. However if I do not grant select permissions on the table the SqlFileStream() class fails to open due to a permission error.

If I grant the SELECT permission I risk a user performing a SELECT * on the table and watch the server die as it is trying to return gigabytes of information.



Related Questions


archiving partitioned filestream table

Updated January 12, 2018 08:06 AM


Guest access to SQL Server Filestream

Updated November 04, 2016 09:02 AM


FileStream Db restore

Updated January 31, 2018 22:06 PM