May 20, 2002 at 8:36 am
I am a new sql server dba. I was given the assignment to setup auditing of modification of passwords and any object in the database. I would appreciate any help in this area.
Charlene
May 20, 2002 at 8:51 am
If you search this site you will find a number of other articles/threads on auditing/security
Also take a look at http://www.sqlsecurity.com
Regards
Steven
May 20, 2002 at 9:37 am
Tough to audit everything. Lumigent provides a product that reads the logs, which will capture most of this if not all. You can also run profiler, but that will be a tough solutions. If you want to audit data, lots of products on the site or methods in the scripts that can help.
Steve Jones
May 20, 2002 at 9:43 am
Thanks for all your suggestions. I am looking more in the area of changes to a login or user password to start with. Also the creation of new logins and users.
Charlene
May 20, 2002 at 4:51 pm
Profiler should work for this. What it doesn't capture is changes to NT user passwords or group memberships - but you can enable auditing in your domain to capture those changes as well.
Andy
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply