Re: Tracking object state for auditing

From: James D Carroll (jamesdcarroll_at_hotmail.com)
Date: 07/09/04 

Date: Fri, 9 Jul 2004 14:23:27 -0400

Yes, the puprose of "tracking" would be to ultimately "audit" the changes
that are made. Unfortunately, creating triggers and the like is not
something the "powers that be" will allow.

"Mark Nicholls" <Nicholls.Mark@mtvne.com>
>
> track?
>
> if you mean simply audit.....
>
> A very very simple way to track changes to data in a database is to
> let the RDB create audit entries in a trigger.
>
> OO - no
> simple, clean and efficient - yes.
>
> obviously if you want to drive events off these changes, then may be
> better done, further up the chain. 

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.717 / Virus Database: 473 - Release Date: 7/8/2004

Relevant Pages

  • Re: Audit logging an adp
    ... Allen Browne's audit code. ... Some people may be tempted to suggest using SQL Server triggers, ... but without an adequate security model your audit trail ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Audit logging an adp
    ... if Access MDB had triggers; I would probably be using it right now lol. ... Allen Browne's audit code. ... Some people may be tempted to suggest using SQL Server triggers, ... but without an adequate security model your audit trail ...
    (microsoft.public.access.adp.sqlserver)
  • Re: How to know which tables is updated ?
    ... You could use profiler to audit certain types of activity & subsequently see what activity has occured through time. ... You could use triggers &/or default values to maintain a list of who & when records are added. ... is there any utility in Sql Server 2000 or any kind of third party tool available? ...
    (microsoft.public.sqlserver.server)
  • Re: Audit
    ... The quickest option is to use Triggers. ... product like Lumigent that audits using the transaction log (and not ... > and store the audit trail in a separate table (prod_table, ...
    (microsoft.public.sqlserver.programming)
  • Re: Results of Altering Trigger NOT FOR REPLICATION
    ... audit tables and they are therefore being kept in synch that way. ... altered the triggers so that they are NOT FOR REPLICATION. ... > the trigger to NFR and replicate both tables. ...
    (microsoft.public.sqlserver.replication)