2

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 columns name mobile no ID salary department

Now I want to mask the complete data in the columns mobileno,Name,ID

Can someone help me with the SQL query without creating a new data this table already exists in the database and need to do masking for the existing table.

Maheshwar Reddy
  • 19
  • 3
  • Please tag your question with the DBMS you are using. Also, please update your question with more information on how you want to mask the data (with examples) and whether it should be masked for everyone or should some people be able to see the unmasked data? – NickW Jun 07 '22 at 11:51
  • You can: 1) Replace the data you want to hide (aka scrubbing, sanitize, masking) effectively losing it, or 2) you can create a view that masks it, while at the same time hiding the original table using permissions. – The Impaler Jun 07 '22 at 12:32
  • Data should be masked for everyone and I am Using IBM DB2 Database. And the data should be complete masked Like In Name(Column) Mahesh It should be completly masked as xxxxxx and mail Id ---xxxxxxxxx@gmail.com – Maheshwar Reddy Jun 07 '22 at 15:00
  • OK then the options provided by @TheImpaler should cover you – NickW Jun 07 '22 at 15:26
  • @NickW But I am looking for a query how to mask – Maheshwar Reddy Jun 09 '22 at 06:54
  • 1) Please tag your question with the DBMS you are using 2) Assuming your DBMS doesn't support its own proprietary masking functionality, are you trying to physically update the values in the columns (so that the original values no longer exist) or are you trying to create a view over the table so the original values still exist in the table but users with only access to the view will only see the masked values? – NickW Jun 09 '22 at 08:09
  • Hi @NickW, Its like there is an existing table and I want to mask the sensitive data and export that table to other database so that the users in that database can only see the masked data – Maheshwar Reddy Jun 13 '22 at 10:30

0 Answers0