SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Workaround for filestream with group


Workaround for filestream with group

Author
Message
thava
thava
SSC-Addicted
SSC-Addicted (499 reputation)SSC-Addicted (499 reputation)SSC-Addicted (499 reputation)SSC-Addicted (499 reputation)SSC-Addicted (499 reputation)SSC-Addicted (499 reputation)SSC-Addicted (499 reputation)SSC-Addicted (499 reputation)

Group: General Forum Members
Points: 499 Visits: 557
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
Gianluca Sartori
Gianluca Sartori
SSC-Insane
SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)

Group: General Forum Members
Points: 23865 Visits: 13362
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

How to post T-SQL questions
spaghettidba.com
@spaghettidba
thava
thava
SSC-Addicted
SSC-Addicted (499 reputation)SSC-Addicted (499 reputation)SSC-Addicted (499 reputation)SSC-Addicted (499 reputation)SSC-Addicted (499 reputation)SSC-Addicted (499 reputation)SSC-Addicted (499 reputation)SSC-Addicted (499 reputation)

Group: General Forum Members
Points: 499 Visits: 557
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search