Questions tagged [dynamic-data-masking]
The dynamic-data-masking tag has no usage guidance.
16
questions
0
votes
1
answer
58
views
Using Dynamic Data Masking in SQL Server set Custom String
I need to mask the data in the following table.
For example, I need to mask the first_name of the user Roberto to something like NAME<<userID>>, So the end result should look like NAME1
...
1
vote
1
answer
123
views
Problem with unmasking a database user during a sproc
I am having an issue with a stored procedure that refreshes dynamic data masking on a database. This sproc is run as a job against all databases on this server.
The problem that I have is that I have ...
- 11
2
votes
1
answer
61
views
Dynamic Data Masking Issue when Concatenating Fields
You can reproduce the issue here:
CREATE TABLE [dbo].[EmployeeDataMasking](
[RowId] [int] IDENTITY(1,1) NOT NULL,
[EmployeeId] [int] NULL,
[LastName] [varchar](50) MASKED WITH (FUNCTION = '...
- 1,952
2
votes
1
answer
140
views
Dynamic Data Masking Doesn't Seem To Work Correctly With ISNULL
Here is the code to reproduce the issue:
CREATE TABLE [dbo].[EmployeeDataMasking](
[RowId] [int] IDENTITY(1,1) NOT NULL,
[EmployeeId] [int] NULL,
[LastName] [varchar](50) MASKED WITH (...
- 1,952
0
votes
1
answer
224
views
How do I limit dynamic data masking with a where clause?
I am interested in using SQL Server dynamic data masking on a subset of rows within a table. Is it possible to do this?
As an example, I have a table of users with email addresses. I do not want to ...
- 193
1
vote
1
answer
172
views
Unable to Mask data after applying mask function in Azure Synapse table
I have created table prd.CustomerDimension
CREATE TABLE [prd].[CustomerDimensions]
(
[WWI Customer ID] [int] NOT NULL,
[Customer] [nvarchar](100) NOT NULL,
[Bill To Customer] [nvarchar](...
- 21
2
votes
3
answers
315
views
Making production data accessible to developers via masking
We want to provide developers in our organization masked data from production to help troubleshoot production issues.
What would be the best way to approach it?
I've read this article https://docs....
- 121
0
votes
1
answer
38
views
dynamic data masking read uncommited
I have read about Dynamic Data Masking and one question is still in my mind. I am wondering what will happen is such scenario:
1. Dynamic Data Masking is set up on table
2. ETL process is loading new ...
0
votes
0
answers
144
views
MySQL Masking and De-Identification
I am currently working on a project to mask and de-identify data and wanted to pass my findings through a sanity check (you guys).
Is it better to create a new view which houses masked data and ...
- 519
0
votes
1
answer
51
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 ...
- 357
1
vote
1
answer
3k
views
How to grant Unmask permission to a user at table level and column level in sql server?
How to grant unmask permission to a user for one particular table and to one particular column within a table?
For example, if in table1 if column1 and column2 is masked and in table2 if column3 and ...
- 131
8
votes
2
answers
877
views
SQL Server: can dynamic data masking be safe when providing a database backup?
I have a SQL Server 2016 SP1 with data that I am ready to share with a partner (developer), except for a few columns, example:
email varchar(64) MASKED WITH (FUNCTION = 'email()') NULL
I give the ...
- 1,407
2
votes
2
answers
2k
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 ...
- 123
1
vote
0
answers
226
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
1
answer
921
views
Dynamic Data Masking performance overhead
I'm thinking of using the new dynamic data masking that has been introduced with SQL Server 2016 as part of our GDPR project . Does anyone else have experience of it? I am particularly interested if ...
- 189
2
votes
1
answer
4k
views
How to check which database roles can see `masked` columns?
In SQL Server 2016 SP1 standard edition we can use dynamic-data-masking. The masking of data is controlled using the built-in security, for example:
REVOKE UNMASK TO ...
- 3,609