up vote 0 down vote favorite
share [g+] share [fb]

I have an AD group as a database user. When I try to drop this group from the database users, using 

DROP USER [this_is_the_ad_group]

the group will be dropped but all the individual users in this group will not. How to delete this group and all its users at once?

link|improve this question
100% accept rate
can you clarify? After adding the group did you also add individual users? If you just add the group, then when removing that group it removes all access for the users as well. If you added the group and its individual users, you'll also have to remove them individually. – MattB Jun 10 '10 at 16:24
No, I added the AD group from Server logins, and then added users to this AD group on ADUC. So I did not add users into this group on SQL Server Management Studio. Removing group DID NOT remove access for users (I'm on SQL Server 2008). – atricapilla Jun 10 '10 at 17:53
feedback

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
or
required, but never shown
discard

Browse other questions tagged or ask your own question.