Week 39 - Security & Governance

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.

create or replace table customer_deets (id int,name string,email string);insert into customer_deets values(1, 'Jeff Jeffy', 'jeff.jeffy121@gmail.com'),(2, 'Kyle Knight', 'kyleisdabest@hotmail.com'),(3, 'Spring Hall', 'hall.yay@gmail.com'),(4, 'Dr Holly Ray', 'drdr@yahoo.com');

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:

1. Sign up as a member of Frosty Friday. You can do this by clicking on the sidebar, and then going to ‘REGISTER‘
2. Post your code to GitHub and make it publicly available (Check out our guide if you don’t know how to here)
3. Post the URL in the comments of the challenge