enable security auditing ..how ?

enable security auditing ..how ?

Post by Hassa » Wed, 25 Jan 2006 14:02:30


Came across this on the checklist for best practises

Enable security auditing
. Enable security auditing of Sysadmin actions, fixed role membership
changes, all login related activity, and password changes.

. After selecting appropriate auditing options, you should
script the audit, wrap it in a stored procedure,and mark that stored
procedure for AutoStart.




But dont really know how to go about it ? Is this part of Profiler ? And if
so, will it be an overkill to run on a continuous basis on a server that may
be highly transactional ?
 
 
 

enable security auditing ..how ?

Post by Michael Ho » Wed, 25 Jan 2006 23:10:52

Which checklist and which version of SQL Server?

--
Mike
http://www.yqcomputer.com/
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.