SQL Server Security - Logins and Groups

[kermitforney]

If I have a user set up in SQL Server w/ Windows Authentication as both a login and a member of a group, do the groups rights and privileges supersede the login's or vice-versa?

 

[ousoonerjoe]

It is my understanding that the user inherits the group settings, but that specific user settings will override any group specifications.

--------------------------------------------------
“Crash programs fail because they are based on the theory that, with nine women pregnant, you can get a baby a month.” --Wernher von Braun
--------------------------------------------------

 

[mrdenny]

The settings will be merged with any DENY overriding any GRANT.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)
MCM (SQL 2008)
MVP

My Blog