May 11, 2007 at 9:15 am
Greetings Folks,
Like many other companies, we too are now implicated in SOX audits.
One of the requirements coming from our auditors is to produce quarterly reports on the accounts active on all our SQL Servers (primarily v2005). This, by itself, isn't too bad.
However, the requirement also calls for reporting on accounts that may have been created and deleted in between reporting periods.
Does anybody know of a practical way to pull this information, assuming it's even available?
best regards,
mikeCC
May 11, 2007 at 9:56 am
Unless available... You'd have to audit this information daily / hourly or howver-ly with a job so you can be sure to catch them all. A snapshot every 3 months would most likely not cover it because a login could have been created and then dropped in that same period.
I sincerly hope there's a better way to do this... maybe a trace running 24/7 for user creations even could be set up, but I don't know what would be the cost of such an operation!
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply