Home icon

Dynamic view-based data masking in Amazon RDS and Amazon Aurora MySQL

Database Blog



The article discusses a view-based data masking solution for Amazon RDS and Amazon Aurora MySQL databases, which allows organizations to protect sensitive information while maintaining data utility.

  • Enables role-based access control for sensitive data
  • Provides real-time, dynamic data masking without creating separate data copies
  • Supports multiple masking types: FULL, PARTIAL, EMAIL, and NONE
  • Requires creating a configuration table, masking function, and stored procedures
  • Allows administrators to control data visibility while preserving data format

Key benefits include flexible data protection, real-time masking, and no additional software requirements. Challenges include manual updates and potential performance impacts.



Go to article

The AWS News Feed is currently looking for gold sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.

Related articles

Dec 30
2024
Dynamic data masking in Amazon RDS for PostgreSQL, Amazon Aurora PostgreSQL, and Babelfish for Aurora PostgreSQL
Nov 24
2025
Amazon Aurora PostgreSQL introduces dynamic data masking
Nov 24
2025
Protect sensitive data with dynamic data masking for Amazon Aurora PostgreSQL
Jun 16
2025
Implement row-level security in Amazon Aurora MySQL and Amazon RDS for MySQL

The AWS News Feed is currently looking for silver sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.