FileStream (FS) associated files access

• Yuri55

  SSCrazy Eights

  Points: 8449

  More actions

  June 2, 2016 at 10:19 am

  #327336

  A bit confused with permission to access FS container.

  As per MS: “If a user has permission to the FILESTREAM column in a table, the user can open the associated files.”

  Does it mean no extra permission on folder level (with FS files) is required?

  Does this include sql account also?

  What account in that case (sql authentication) used to access FS container- sql server service?

  Thanks

• subramanian.esakkimuthu 40485

  SSCrazy

  Points: 2022

  More actions

  June 3, 2016 at 1:10 am

  #1883001

  if you have the sql access to these column and it will allow you to access the file stream data using your managed api.

• Yuri55

  SSCrazy Eights

  Points: 8449

  More actions

  June 3, 2016 at 7:54 am

  #1883092

  Hmm,

  But in accordance with MS blog:

  https://blogs.msdn.microsoft.com/psssql/2008/04/10/how-it-works-file-streams-requires-integrated-security-windows-authentication/

  "File Streams only support integrated security access. The Windows HANDLE model does not understand SQL Server logins"

  Am I missing anything there?

  Thanks

• joeroshan

  SSChampion

  Points: 10377

  More actions

  June 3, 2016 at 8:02 am

  #1883094

  Yup. Filestream supports only window authentication. But there is a workaround though.

  http://www.sqlskills.com/blogs/bobb/using-filestream-streaming-io-and-sql-logins-with-impersonation/

  ----------------------------------------------------------------------------------------------------------------------------------------------------
  Roshan Joe

  Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help[/url]