Audit trails and data security go hand in hand and it is highly desirable that this functionality is built-in.

Lianja database timelines provide row versioning for database tables for all CRUD operations performed on data. Whenever a change is made to a table that is timeline enabled then delta changes are automatically recorded for each transaction. Changes made to any tables that are timeline enabled can be undone much like you would undo changes to program code that you edit in a text editor.

Database timelines record who did what from where, when did they do it and what did they change. An invaluable feature for SaaS applications.In Lianja 4.1 you can enable timelines globally for a database.

alter database yourdatabase metadata "timeline=on"

This will enable timelines for all non temporary tables contained within the database. You can disable timelines for individual tables like this:

alter table yourtable metadata "timeline=off"


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 )

Google+ photo

You are commenting using your Google+ 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 )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.