Re: enable security auditing ..how ?
- From: "Michael Hotek" <mike@xxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 24 Jan 2006 08:10:52 -0600
Which checklist and which version of SQL Server?
--
Mike
http://www.solidqualitylearning.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.
"Hassan" <Hassan@xxxxxxxxxxx> wrote in message
news:O7RFiNKIGHA.3936@xxxxxxxxxxxxxxxxxxxxxxx
> 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 ?
>
.
- References:
- enable security auditing ..how ?
- From: Hassan
- enable security auditing ..how ?
- Prev by Date: Re: SSL info
- Next by Date: Re: how to encrypt db files
- Previous by thread: enable security auditing ..how ?
- Next by thread: how to encrypt db files
- Index(es):
Relevant Pages
|
|
