Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Can't login User or Group?

Author  Topic 

denis_the_thief
Aged Yak Warrior

596 Posts

Posted - 2013-04-08 : 11:03:08
One user is stuck and can't log into a Database using Windows Authentication (although the same user can access a different Database on the same server). The permission is assigned to the User's Windows Login but not assigned to the User's Windows Group.

That made me wonder, when you login, do you get the priviledges of the User or the Group? Or if you have a link on the topic, that would also help.

Denis

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2013-04-08 : 11:49:29
You get all the privileges of the group AND all of the privileges of the individual login.
Go to Top of Page
   

- Advertisement -