enhancementhelp wanted
Métricas do repositório
- Stars
- (16.744 stars)
- Métricas de merge de PR
- (Mesclagem média 23h 19m) (1 fundiu PR em 30d)
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.