Re: Audit log that SA cannot modify
- From: "Uri Dimant" <urid@xxxxxxxxxxx>
- Date: Wed, 15 Feb 2006 16:40:19 +0200
Hi
Don't you trust in SA? :-))))))
Remove people that you don't want from sysadmin server role and then you
audit them by using triggers
<jasonshohet@xxxxxxxxx> wrote in message
news:1140012486.489277.187450@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
But the SA can disable the trigger, thats not enough.
I want something that can audit the SA himself - and anyone else. It
should report on all schema changes and all transactions made to the db
- by anyone - and nobody should be able to modify it (including the SA)
except truncate the log by date range at the end of the audit period.
.
- Follow-Ups:
- Re: Audit log that SA cannot modify
- From: jasonshohet
- Re: Audit log that SA cannot modify
- References:
- Audit log that SA cannot modify
- From: jasonshohet
- Re: Audit log that SA cannot modify
- From: Uri Dimant
- Re: Audit log that SA cannot modify
- From: jasonshohet
- Audit log that SA cannot modify
- Prev by Date: Re: Audit log that SA cannot modify
- Next by Date: SQLServer 2000: Assign permissions on ALL tables to an app role
- Previous by thread: Re: Audit log that SA cannot modify
- Next by thread: Re: Audit log that SA cannot modify
- Index(es):
Relevant Pages
|
|
