November 23, 2009 at 10:51 pm
Hi there. How can I trap users who are using an admin account? We have one login account that has administrative priviledges. This is being used by our systems, so our programmers know the password. But we are now implementing individual limited user accounts to the programmers without deleting the admin account being used by our systems. Is there any way I can detect who are the users using the admin account?
For example, when programmer1 logs to query analyzer using the admin account instead of his own account, is there any way I can be notified?
November 24, 2009 at 7:40 am
If you are on SQL Server 2000 as the forum implies, I think your only choice is to setup a server-side trace[/url]. Then you can query the trace file using fn_trace_gettable() to see when the admin account is used and you can see what machine they connected from.
Another option is to create all the individual accounts, send each individual their new account information and then disable/delete the admin account and wait to see who cries about it.:w00t:
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
November 24, 2009 at 9:15 am
Server side trace is your only option. My recommendation is to schedule the downtime, make the password change, and update the systems. You'll spend a whole lot less time doing that than tracking this down, if you can absorb the downtime.
K. Brian Kelley
@kbriankelley
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply