USE BikeStores;
GO

ALTER TABLE Sales.customer_credit_cards  
	ALTER COLUMN credit_card_number VARCHAR(50)
	MASKED WITH (FUNCTION = 'partial(0,"XXXXXXXXXXXX",0)'); 
GO

ALTER TABLE Sales.customers  
	ALTER COLUMN email VARCHAR(255) 
	MASKED WITH (FUNCTION = 'email()'); 
GO

GRANT UNMASK TO Salesperson;
GO

EXECUTE AS USER = 'Vanessa';
SELECT * FROM Sales.customer_credit_cards;  
REVERT;   
GO

EXECUTE AS USER = 'Will';
SELECT * FROM Sales.customer_credit_cards;  
REVERT;   
GO

EXECUTE AS USER = 'Vanessa';
SELECT * FROM Sales.customers;  
REVERT;   
GO

EXECUTE AS USER = 'Will';
SELECT * FROM Sales.customers;  
REVERT;   
GO