May 19, 2021 at 6:45 pm
I would like to see which accounts in SQL are actively using databases. When I look at results from a trace file, I can see individual users, who do not have specific permissions. For example, I see that "MyDomain\Joe_Smith" accessed "Sales_DB". although Joe_Smith doesn't have SQL permissions.
I suspect they are in an Active Directory group that has the permission. I don't have direct access to Active Directory to see what group Joe_Smith is in.
Is there a way within SQL to see which logins such as "MyDomain\Group1" are accessing databases ?
May 19, 2021 at 9:35 pm
Use xp_logininfo and pass in the group name and the members option and it will list the members of the group.
Or if you have the ad powershell modules you can use get-adgroupmember
May 24, 2021 at 4:38 pm
Thanks ! xp_logininfo will work for me.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply