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 brokenMyBlog About Common dialog controlA Visualizer for viewing SqlCommand object script