Questions tagged [dynamic-data-masking]
17 questions
3
votes
1 answer
Changing masking policy without unsetting that masking policy
Is it possible to alter an existing masking policy without unsetting this policy?
For example, I have a masking policy that is set to multiple columns. So, when I want to change the policy to include more roles, I have to first unset the policy from…
Selin
- 55
- 1
- 4
2
votes
1 answer
How to use Dynamic Data Masking with FOR XML PATH and subqueries
I'm trying to generate XML from a database and using the Dynamic Data Masking for hiding sensitive information but when I execute my stored procedures that generate the XML as the user who should only see the masked data, the finished XML lacks the…
user16742112
- 21
- 4
1
vote
1 answer
How to Mask PII data in AWS ORACLE RDS?
I am trying to mask PII data without any encryption/decrytion at application level. WHat are the different ways to mask the data.
Azure provides out of box service, where we can give schema name and column name for maksing the data, but couldn't…
HMT
- 2,093
- 1
- 19
- 51
1
vote
1 answer
SQL Server Data Masking bug with "FOR JSON PATH" clause
I'm working with a masked database on my QA server using SQL Server Standard (64-bit) 14.0.1000.169. This is my structure:
CREATE TABLE [dbo].[Test](
[Column1] [VARCHAR(64)] NULL,
[Column2] [VARCHAR(64)] NULL
)
GO
…
Moises Hernandez
- 11
- 2
1
vote
1 answer
T-SQL :: information_type is not parsed in SQL Server 2019
My query doesn't seems to parse information_type
STEP TO REPRODUCE:
Take AdventureWork or any other test database
Right click on your test database > Tasks > Data Discovery and Classification > Classify Data... and classify a bunch of data
Now…
Francesco Mantovani
- 10,216
- 13
- 73
- 113
1
vote
1 answer
How to create a custom function for Dynamic Data Masking
I'm testing Dynamic Data Masking and I discovered that SQL Server propose only 4 functions out of the box:
Function
Examples
Default
Example of alter syntax: ALTER COLUMN Gender ADD MASKED WITH (FUNCTION = 'default()')
Email
Example of…
Francesco Mantovani
- 10,216
- 13
- 73
- 113
1
vote
1 answer
azure sql dynamic data masking multiple policies or groups
I'm trying to use the Dynamic data masking in Azure SQL database.
What I'm trying to achieve is that I want to have multiple masking policies for multiple AAD groups.
For example a table has 4 columns and I have 3 AAD groups:
Group 1 should see…
Toofle
- 214
- 1
- 2
- 11
0
votes
0 answers
How is Data masking price calculated in BigQuery
We run 2 queries from a table in 2 scenarios:
We run a query to create a table from selecting data of another table (ex: ABC), this table ABC has no any policy tags (data masking rules) on any columns:
create table project.dataset.ABC_NOT_MASKED as…
Hue Truc
- 9
- 2
0
votes
0 answers
Masking entire table with one line of script - Microsoft Dynamic Data Masking
is there a way in Microsoft Dynamic Data Masking (DDM) to mask an entire table in sql server with just one line of script using the same function for all columns? defining the masking rule on the table as a whole?
something like: ALTER TableName ADD…
layan
- 1
0
votes
0 answers
Performance Effective JSON data masking Snowflake
I am trying to perform data masking on JSON data.
Using a Javascript UDF to update list of NESTED JPATH attributes similar to what is done here,
https://www.snowflake.com/blog/masking-semi-structured-data-with-snowflake/
Additionally I tried nested…
Ankit Srivastava
- 57
- 7
0
votes
1 answer
How can I create multiple users with different masking types using Dynamic Data Masking in SQL?
When I try to create new users with different masking types, the masking type of the last user I created is constantly defined for all users, how can I create this correctly. This is how I do the user creation:
CREATE LOGIN test1
WITH PASSWORD =…
0
votes
1 answer
Dynamic Data Masking in SSAS cube process
I have dynamic masked data in my SQL Server DB and I want to know what will happen to that if I used this data in my cube processing . would it be still a masked data is the cube , and can I use the roll security for that or not?
salomevala
- 1
- 1
0
votes
1 answer
sys.types returns wrong data type
My goal is to script out and export Dynamic Data Masking.
In order to do so I have created a query that allows me to create the code dynamically:
SELECT
schema_name(tbl.schema_id) AS schema_name,
tbl.name as table_name,
mc.name AS column_name,…
Francesco Mantovani
- 10,216
- 13
- 73
- 113
0
votes
2 answers
Snowflake: Dynamic Data Masking Impact On query results
I have discovered that a query against a table that has a masked policy will return different results based on the role IF a masked column is part of the predicate or a JOIN.
The following query will return no data:
use role NO_READ_ROLE;
select *…
Dave_T
- 1
- 1
0
votes
1 answer
Using same masking policy for different data types
For a project I have to set a masking policy on multiple columns. These columns have different data types (e.g., varchar, date, number...). Is it possible to use the same masking policy on these different columns?
Here you can see my masking policy…
Selin
- 55
- 1
- 4