Re: Which User account is used?
- From: "Dan Guzman" <guzmanda@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 25 Sep 2008 06:36:45 -0500
How does SQL Server decide which User account is used when this user
connects to the database?
You can check the actual permission path using xp_logininfo.
EXEC master..xp_logininfo 'MyDomain\GroupMember,'all'
The xp_logininfo documentation (http://msdn.microsoft.com/en-us/library/ms190369.aspx) implies that admin privilege Windows group membership takes precedence over non-admin group membership and that the earliest granted Windows group is the one used for ties.
--
Hope this helps.
Dan Guzman
SQL Server MVP
http://weblogs.sqlteam.com/dang/
"kh" <kh@xxxxxxxxxxxxx> wrote in message news:4684D796-8E26-434B-BA9F-EAD2EB57759E@xxxxxxxxxxxxxxxx
Hi. In SQL Server 2005 with Windows Authentication mode activated, I have a
user who is a member of an AD group which has been assigned as a database
User, but this user's login has also been associated with another User
account directly.
How does SQL Server decide which User account is used when this user
connects to the database?
Thanks
.
- References:
- Which User account is used?
- From: kh
- Which User account is used?
- Prev by Date: Facing Error: 15401 while creating local logins
- Next by Date: Re: Stored Procedure / GrantDbAccess
- Previous by thread: Re: Which User account is used?
- Next by thread: Security Question
- Index(es):
Relevant Pages
|
