new release of the project , providing an add-on to the PostgreSQL database management system that addresses the task of hiding or replacing confidential data or information that constitutes a commercial secret. Data can be obscured on-the-fly based on specially defined rules and lists of users whose queries need to be anonymized. Code under the PostgreSQL license.
For example, using this add-on, access to the database can be provided to third parties, such as external business analytics services, automatically removing data such as phone numbers and credit card information, or applying more sophisticated methods, such as replacing the names of clients and companies with fictitious information. In addition to performing anonymization when directly connected to the DBMS, there is a mode for creating anonymized SQL dumps (the utility pg_dump_anon is proposed).
PostgreSQL Anonymizer PostgreSQL DDL (Data Definition Language) and allows you to define an anonymization strategy at the schema level, specifying the structure of the table. A large set of functions is provided for processing data to be replaced: randomization, replacement with fictitious values, partial , shuffling, noise addition, etc. The new version includes functions for identifying identifiers and has introduced a pseudonymization mode that allows the generation of realistic fictitious values tied to the original data.
Additionally, it is worth noting the open platform developed by Microsoft for detecting leaks of confidential information . The platform allows for the detection or removal of information in documents, text, and images that contains personal and confidential data such as names, phone numbers, emails, credit card numbers, cryptocurrency wallets, addresses, passport numbers, financial data, etc. It supports processing various storage systems (from Amazon S3 to PostgreSQL) and formats. The code is written in Go (with a Python version available) and is licensed under the MIT License.
Source: opennet.ru
