Security is a top concern at Frosty Friday, and we need to make sure that not just anyone can see our customer’s contact info.
Run the following script
create or replace table customer_deets ( id int, name string, email string ); insert into customer_deets values (1, 'Jeff Jeffy', 'email@example.com'), (2, 'Kyle Knight', 'firstname.lastname@example.org'), (3, 'Spring Hall', 'email@example.com'), (4, 'Dr Holly Ray', 'firstname.lastname@example.org');
Apply a column level masking policy that shows me the following when I query using my role:
And the following when I query using any other role:
Remember, if you want to participate: