Questions tagged [data-masking]

Data Masking is the act of replacing meaningful data with non-meaningful, or "masked" data to be used during development, and testing, etc. This is generally used to protect personally identifiable information from being seen outside of a production system.

Filter by
Sorted by
Tagged with
0
votes
1answer
25 views

On what basis DMA identifies columns for Dynamic Data Masking?

Can anyone help me explain on what basis 'Data Migration Assessment' features recommendation suggests for Dynamic Data Masking and displays certain objects/tables columns for masking. On what basis ...
-1
votes
0answers
36 views

How to mask a column permanently in SQL Server? [duplicate]

I have to create an UAT testing environment of my production database and hand it over to developers, but I want to mask certain columns permanently, so they cannot view the actual data at all. How ...
1
vote
1answer
37 views

Data redaction with regex in Oracle

I would like to redact data with regex in oracle database. I know the procedure but I get unpredictable results. I use the following script to apply redaction to a certain column with card numbers. ...
0
votes
1answer
222 views

Static Data Masking does not appear in SSMS 18 preview 6

I installed SSMS version 18 preview 6 and am using it with SQL Server 2017. I want to test the Static Data Masking feature, but the option does not appear.
2
votes
2answers
113 views

Masking PII columns in Oracle

I am using Oracle 11g R2 on Linux, and I have multiple tables in my database that has got columns that needs to be masked. I have tried the OEM to mask the data as mentioned in the below hyperlink, ...
1
vote
5answers
2k views

Create Random Number up to 50 Digits and Store in Varchar

Does anyone have code; looking for a random number function generator. I would just supply with a variable length @NumberLength = 50, etc. It can create numbers up to 50 digits, and store in varchar. (...
1
vote
1answer
731 views

Create Random Word to obfuscate a SQL Column

Does anyone have any SQL code to automatically generate words (all letter, no number). Is there any inline SQL to perform this on a column? We are trying to obfuscate first/last name and other word ...
4
votes
4answers
3k views

Create SQL Randomized Date of Birth

Does anyone have any SQL code to automatically generate randomized birth dates, where the date of birth is less than today? Please add Date of Birth Range parameters, eg: from 18 to 70 years old. Is ...
2
votes
2answers
1k views

Can't create indexed view against table with masked columns

I am trying to create an index on a view that references a table with a masked column (SQL Server 2016). The masked column is not the only one in that table, and it's not used in the view. create ...
1
vote
0answers
138 views

Get current-processed column information in Oracle datapump

In order to mask data I am using REMAP_DATA parameter in Oracle datapump as follows: expdp \'/ as sysdba\' DIRECTORY=DUMP_DIR DUMPFILE=dumpfile.dmp LOGFILE=logfile.log SCHEMAS=user0 REMAP_DATA=user0....
1
vote
1answer
690 views

Dynamic length obfuscation method in T-SQL

I would like to obfuscate (scramble) sensitive data from a SQL Server database, but in the way which will provide: irreversibility (the plaintext can't be derived from the obfuscated data), ...
1
vote
1answer
853 views

Scramble / masking data from SQL Server [closed]

I need to share a SQL Server 2008 R2 DB with the development team. The data is classified but the schema and the volumes are not. The DB includes all primitive types (long, decimal, nvarchar etc.) but ...
4
votes
2answers
10k views

Scrubbing sensitive data

I am looking for an automated solution to scrub sensitive data from my prod environment to my DEV and DEVINT environments so that I don't have to write lots of code to get this done. Does anyone know ...