May 8, 2003 at 5:05 am
Hello! I got a problem. We got a lot of old SQL Account in a server. Maybe it’s only 10% that is in use. So my question is if anyone of you knows how to see when an account was last used. If no one has used it in a year I will delete the account.
Thank from Joel
May 8, 2003 at 2:42 pm
There is now way you can check that if you haven't implemented before a way to save when a user last connected.
You can search you db to see if the user that you want to delete is the owner of any object in the db. If not maybe you can drop it, but this doesn't mean that anyone is going to still use it.
May 9, 2003 at 3:44 am
You can also audit your logins with either Profiler to capture connections or if you right click the Server in question in EM and choose properties you will find Audit level options on the Security tab (you will have to stop and restart the service to use this and to turn off).
May 9, 2003 at 3:46 am
Ok, thanks. Know I have some hour to handle this manualy instead 🙂
Have a good weekend.
/Joel
May 15, 2003 at 5:59 pm
You can also run sp_validatelogins to quickly find any orphaned Windows NT users and groups that no longer exist in the NT environment but still have entries in the SQL Server system tables. That may narrow the list you have to manually research.
David R Buckingham, MCDBA,MCSA,MCP
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply