Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Workaround for filestream with group Expand / Collapse
Author
Message
Posted Tuesday, April 29, 2014 8:14 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, September 14, 2014 12:30 AM
Points: 253, Visits: 540
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
Post #1565945
Posted Wednesday, April 30, 2014 7:53 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 2:05 AM
Points: 4,323, Visits: 10,572
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:
http://blogs.msdn.com/b/ikovalenko/archive/2007/01/27/workaround-for-unable-to-set-default-schema-for-a-group.aspx


--
Gianluca Sartori

Get your two-cent-answer quickly
spaghettidba.com
@spaghettidba
Post #1566407
Posted Wednesday, April 30, 2014 6:11 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, September 14, 2014 12:30 AM
Points: 253, Visits: 540
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
Post #1566627
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse