By Jayaram Krishnaswamy | Article Rating: |
|
June 3, 2018 08:54 PM EDT |

Go
SELECT FirstName, LastName, City
FROM Employees
Now I will apply a datamask to the FirstName column with a default() datamask using the following Alter Table, Alter Column statements.
Go
Alter table Employees
Alter Column FirstName nvarchar(10) Masked with (Function='default()')
GRANT SELECT ON EMPLOYEES TO hacker3;
EXECUTE AS USER='hacker3'
DataMask_01
Read the original blog entry...
Published June 3, 2018
Copyright © 2018 SYS-CON Media, Inc. — All Rights Reserved.
Syndicated stories and blog feeds, all rights reserved by the author.
More Stories By Jayaram Krishnaswamy
Jayaram Krishnaswamy is a technical writer, mostly writing articles that are related to the web and databases. He is the author of SQL Server Integration Services published by Packt Publishers in the UK. His book, 'Learn SQL Server Reporting Services 2008' was also published by Packt Publishers Inc, Birmingham. 3. "Microsoft SQL Azure Enterprise Application Development" (Dec 2010) was published by Packt Publishing Inc. 4. "Microsoft Visual Studio LightSwitch Business Application Development [Paperback] "(2011) was published by Packt Publishing Inc. 5. "Learning SQL Server Reporting Services 2012 [Paperback]" (June 2013) was Published by Packt Publishing Inc. Visit his blogs at: http://hodentek.blogspot.com http://hodentekHelp.blogspot.com http://hodnetekMSSS.blogspot.com http://hodnetekMobile.blogspot.com He writes articles on several topics to many sites.
Feb. 18, 2019 09:00 PM EST |
By Pat Romanski ![]() Feb. 18, 2019 08:45 PM EST |
By Zakia Bouachraoui ![]() Feb. 18, 2019 08:30 PM EST |
By Pat Romanski Feb. 18, 2019 08:00 PM EST |
By Roger Strukhoff Feb. 18, 2019 05:45 PM EST |
By Yeshim Deniz ![]() CloudBees, Inc., the hub of enterprise Jenkins and DevOps, today announced a major investment in Kubernetes technology across all areas of the business. CloudBees has made Kubernetes a key part of its lon... Feb. 18, 2019 04:45 PM EST |
By Pat Romanski Feb. 18, 2019 04:15 PM EST |
By Zakia Bouachraoui ![]() Feb. 18, 2019 04:00 PM EST |
By Yeshim Deniz Feb. 18, 2019 03:30 PM EST |
By Elizabeth White Feb. 18, 2019 03:30 PM EST |
By Janakiram MSV Serverless Computing or Functions as a Service (FaaS) is gaining momentum. Amazon is fueling the innovation by expanding Lambda to edge devices and content distribution network. IBM, Microsoft, and Google have their own FaaS offerings in the public cloud. There are over half-a-dozen open source serverless projects that are getting the attention of developers. Feb. 18, 2019 03:15 PM EST |
By Jnan Dash ![]() Feb. 18, 2019 03:00 PM EST |
By Stackify Blog ![]() Feb. 18, 2019 02:45 PM EST |
By Zakia Bouachraoui Feb. 18, 2019 02:30 PM EST |
By Pat Romanski ![]() Feb. 18, 2019 02:30 PM EST Reads: 107 |