Auditing Triggers

Ukończone Opublikowano May 3, 2005 Płatność przy odbiorze
Ukończone Płatność przy odbiorze

I am working with an IT Automation software that schedules batch processing. It allows you to define Batch Jobs and the parameters required to get them to run at pre-determined times in some pre-determined order. Each of these batch "Jobs" are stored in a database. There are about 27 tables that make up each jobs definition. They are all tied together by:

**PK,FK1 TABLE_ID float**

**PK,I1 JOB_ID float

**Daily these definitions are copied into an active section of the database (a different set of tables) where they run. This allows users to change todays version but not the normal schedule.

I need to track any and all changes made to these "Jobs".

I need a trigger that will watch the tables that make up a job and when a change is found, it must write out the following information:

Date

Time

User making the change (This may be the result of a query against another table as there is only one product ID at the DB level)

Field Changed

Old Value

New Value

I need each of these changes written out to a table I can report out of.

## Deliverables

Deliverables:

4 Database Triggers (multiple if needed to run at the table level instead of the DB level) - 2 (or more) for Oracle and 2 (ore more) for SQL Server. The database schema is the same for both DB types but since the product can run under SQL as well as Oracle, I need to track both.

These triggers must be fully tested. I can provide database dumps/backups for testing.

I am including a zip with 2 DB schemas.

1 Trigger will go against the CEM612-DB Poster. For this one, I am interested in the purple Job Definitions Tables.

The other Trigger will go against the CTM610-DB-poster. This one goes against the Green Active Jobs tables.

Both Triggers can write out to a new table created in the same database as the chages are found.

## Platform

This is a request for DB Triggers. I need the same triggers for both MS-SQL 2000 and Oracle 9i.

Inżynieria MySQL Oracle PHP Architektura oprogramowania Testowanie oprogramowania SQL

Numer ID Projektu: #3697410

O projekcie

1 oferta Zdalny projekt Aktywny May 3, 2005

Przyznany użytkownikowi:

MarkTime

See private message.

$63.75 USD w ciągu 15 dni
(2 ocen)
1.9