Questions tagged [sql-masking]
5 questions
2
votes
0 answers
Masking data in the existing table
I am looking to mask the data(Columns) in the existing table without creating a new table and sensitive data(Columns) like Name, Mailid, phone number etc...
Can someone help me with the query.
Lets think we have a table(Empsal) with…
Maheshwar Reddy
- 19
- 3
2
votes
1 answer
How to mask a specified field in a table when I query it using big query?
I want to mask a specified field in a table when I query it using big query. For example: a table named employee has email-id column, so when I query the table all the email-id field should be masked with ****.
How can I do it using DLP in google?
2
votes
4 answers
How to replace a string value with single character
I want to mask the data except the last four characters.
For example:
If there is a varchar column (Name) with the value Rio De janerio, I want to mask it as xxx xx xxxerio.
If it is a numeric column (acc number) with value 123 453 6987,then I…
MRR
- 83
- 3
- 9
0
votes
0 answers
SQL Server Column Masking Function Does Not Keep Mask Format In SQL Computed Column Or View - Just X's
I'm using the SQL Dynamic Masking on columns in my table (LastName, SecondaryLastName). Those columns both contain the same masking function.
Function: MASKED WITH(FUNCTION = 'partial(1,"***", 1)')
Both LastName and SecondaryLastName Column Values…
billy_comic
- 867
- 6
- 27
0
votes
2 answers
SQL SERVER generate data using Regex pattern
I would like to generate the data by given regex pattern in SQL Server. Is there any possibility to do? Say, I have pattern as below and I would like to generate data as follow:
The idea behind the concept is SQL STATIC DATA MASKING (which was…
user12341821