Workaround for filestream with group
-
Hi,
I have faced a difficult situation here,
This is my scenario,
In our company, we need to implement the filestream in SQL server 2008 R2 for our database, since it is filestream we need a windows authentication in our server, but the problem is we have hundred of users in our company, so setting permission for each user is not possible, hence we decide to assign group based permission for all the users, we already set the permission based on the default schema for sql Authentication, now we are not able to set a default schema for the group, (i.e.)assigning permission for each group is not possible based on default schema
in short i have a database with filestream, how can i set authentication(securables in management studio) based on a particular windows group, and that authentication will apply all to its users
anybody have any idea about this kind of workout?
Every rule in a world of bits and bytes, can be bend or eventually be broken
MyBlog About Common dialog control
A Visualizer for viewing SqlCommand object script [/url] -
Assigning a default schema to a group is not possible in SQL Server until 2012. All previous versions (including 2008 R2) do not allow this.
Granting permissions is a whole different story and it can be done.
See here for details:
-- Gianluca Sartori
-
Once I will test it and let you know
Every rule in a world of bits and bytes, can be bend or eventually be broken
MyBlog About Common dialog control
A Visualizer for viewing SqlCommand object script [/url]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply