Auditing

Auditing is an important aspect in any decent enterprise system. The  important reward from auditing is perhaps – traceability. By having audit done, we are able to know who did what and when. Without audit, we are in the blind and we can’t find out what are the cause(s) when something goes wrong.

Modern databases boast exceptional auditing features. However, there is always a gap between what the DB audit functionality provides and the business auditing  needs. For example, DB audit can only record the CRUD done by a DB user account. Typically, the DB user account doesn’t map to a specific end-user account in the enterprise system that uses the DB. Moreover, businesses are more interested in knowing what business operations were performed by a particular user at a particular time, with the pre-and-post results. DB auditing won’t be able to capture such information.

If you know of any bridging framework or DB tools, do let me know!

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: