CHANGELOG

2019FIXME : 0.3 - In-place Anonymization and Anonymous dumps

Dependencies: - tms_system_rows - ddlx

In-place Anonymization : Permanently remove sensitive data with anonymize_database(), anonymize_table() or anonymize_column().
Anonymous dumps : Export the entire anonymized database with the new dump() function. For instance:

console $ psql -q -t -A -c 'SELECT anon.dump()' the_database
Dynamic Masking : new functions start_dynamic_masking() and stop_dynamic_masking()
shuffle an entire column with the new function : sql SELECT anon.shuffle_column('employees','salary', 'id');
Add +/-33% of noise to a column with: sql SELECT anon.numeric_noise_on_column('employee','salary',0.33);
Add +/-10 years of noise to a date with : sql SELECT anon.datetime_noise_on_column('employee','birthday','10 years');
Renamed faking functions for clarity
FIX #43 : Using unlogged tables was a bad idea
FIX #51 : tests & doc about explicit casting
Add autoload parameter to mask_init function. Default to TRUE for backward compatibility
Add anon.no_extension.sql for people in the cloud
[masking] Improve security tests

Declare a masked column with : sql COMMENT ON COLUMN people.name IS 'MASKED WITH FUNCTION anon.random_last_name()';
Declare a masked role with : sql COMMENT ON ROLE untrusted_user IS 'MASKED';

Checkout demo/partial.sql and demo/masking.sql for more details