Garantindo a conformidade com a LGPD: estratégias de mascaramento e anonimização de dados para amientes de banco de dados

Abstract

With the implementation of the General Data Protection Law (LGPD), companies and organizations are facing significant challenges in ensuring compliance with strict data privacy requirements. This study investigates and apply data masking and anonymization techniques in a PostgreSQL environment to meet LGPD requirements, focusing on the role of the Database Administrator (DBA). A review of the literature on the LGPD and its implications for data management is carried out, followed by the identification and analysis of data masking and anonymization techniques applicable in PostgreSQL databases. The selected techniques are implemented and tested, evaluating their effectiveness in preserving the usefulness of data for analysis, while ensuring compliance with LGPD requirements. Challenges and limitations encountered during implementation are discussed, along with possible solutions. The results highlight the importance of data masking and anonymization strategies in PostgreSQL to assist DBA’s in protecting personal data and complying with the LGPD.