THE Book on FILESTREAM and FileTable
The Art of SQL Server FILESTREAM
My Blog Posts
Frequently Asked Questions
- I want one group of users to have read-only access and another group of users to have read-write access to a FileTable. Can it be done?
In short, no.
This deals with row level security, which SQL Server does not currently support. See http://connect.microsoft.com/SQLServer/feedback/details/688000/filetable-permissions-enhancements
- In which update has the FileTable security flaw been resolved?
It has been resolved in Service Pack 1. Be careful, because none of the RTM’s Cumulative Updates, including CU 5 released after SP 1 have the fix.
I am continuing to test with every CU that Microsoft releases for RTM and will update the original blog post and this page when I find if it’s been resolved.