March 24, 2016 at 2:01 pm
Hi,
I need to find which user\login lately accesses SQL databases. we are trying to remove any unused logins which are not accessing databases for more than 6 months but no idea who is accessing and when.
Can someone share any scripts.
March 24, 2016 at 3:39 pm
The Database log will show users, however its hard to work with so I suggest something else. Remove all all individual users and replace them with active directory groups. Then users move in and out of the groups without all the hassle on SQL security. It will take time to organize those groups, but it will save tons of time in the future adding and removing individual users so in the long run it saves.
Not what you asked for, but hope it helps.
March 28, 2016 at 1:05 pm
You could create a logon trigger to capture which logins are being used, and how often.
SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply