ON lt.principal_id = sp.principal_id AND sp.type != 'R' Xp_logininfo EXEC xp_logininfo 'DC\Somebody','all' To get the AD groups with exsting logins on the instance that your login DC\Somebody belongs to Which login will it take ? It appears to be the alphabetically first. This are the functions I tried so far, without success: SELECT - Īlso, what happens if multiple groups are added as sql-server logins, and I'm a member of them all, and then I login with integrated security. All I can get is the username (DC\Somebody). I'm now trying to get the SQL-Server login (by which I mean DC\Developers), but I can't figure out how. Now SQL-Server has the login group called DC\Developers, and with that, I can login on the server with integrated security. Let's say I'm a user in windows domain DC (DataCenter).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |