text: CREATE TABLE Membership
  (
      MemberID int IDENTITY PRIMARY KEY,
      FirstName varchar(100) MASKED WITH (FUNCTION = 'partial(1,"XXXXXXX",0)') NULL,
      LastName varchar(100) NOT NULL,
      Phone varchar(12) MASKED WITH (FUNCTION = 'default()') NULL,
      Email varchar(100) MASKED WITH (FUNCTION = 'email()') NULL
  );
  
  INSERT Membership
      (FirstName, LastName, Phone, Email)
  VALUES
      ('Roberto', 'Tamburello', '555.123.4567', 'RTamburello@contoso.com'),
      ('Janice', 'Galvin', '555.123.4568', 'JGalvin@contoso.com.co'),
      ('Zheng', 'Mu', '555.123.4569', 'ZMu@contoso.net');
  SELECT *
  FROM Membership;
  
  CREATE USER TestUser WITHOUT LOGIN;
  GRANT SELECT ON Membership TO TestUser;
  
  EXECUTE AS USER = 'TestUser';
  SELECT *
  FROM Membership;
  REVERT;