enhancementhelp wanted
Métriques du dépôt
- Stars
- (16 744 stars)
- Métriques de merge PR
- (Merge moyen 23h 19m) (1 PR mergée en 30 j)
Description
SQL Server, for example, has a neat feature, which is useful for data protection:
What you can do is attach a "masking policy" to a column in a table. For example, email addresses (that are personal information) could be masked by having a MASKED WITH augmentation on a SQL table:
CREATE TABLE users(
email TEXT MASKED WITH (FUNCTION = 'email()') NOT NULL,
);
Queries to the table would mask out the email address with an anonymized "anon@example.com" version, for example. However, users could still see their own email addresses with another SQL extension that SQL Server has:
EXECUTE AS USER = 'penberg';
Dynamic data masking is particularly useful in scenarios where database is replicated and you want the extra layer of protection while still serving queries. Please note that there's bound to be some overlap with LumoSQL security features here.