You may see a Windows user accessing SQL Server but they are not showing as a login.
The following command should assist with showing which security group(s) gives them access.
EXEC xp_logininfo 'yourdomain\usersname','all';
You may see a Windows user accessing SQL Server but they are not showing as a login.
The following command should assist with showing which security group(s) gives them access.
EXEC xp_logininfo 'yourdomain\usersname','all';
© 2011-2023 AKAWN®. All rights reserved. Privacy Policy.