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', '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:
- Sign up as a member of Frosty Friday. You can do this by clicking on the sidebar, and then going to βREGISTERβ
- Post your code to GitHub and make it publicly available (Check out our guide if you donβt know how to here)
- Post the URL in the comments of the challenge
5 responses to “Week 39 – Basic”
-
I’m a big fan of the recent(ish) addition to the functionality where you can use other fields in the data too
- Solution URL – https://github.com/ChrisHastieIW/Frosty-Friday
-
Here’s my solution
- Solution URL – https://github.com/apd-jlaird/frosty-friday/blob/main/week_39/ff_week_39.sql
-
It’s good that ChatGPT can now write a regex π
- Solution URL – https://github.com/mateusz-kmon/frostyfridaychallenges/blob/main/w39.sql
-
Thanks for the challenge! π
- Solution URL – https://github.com/dsmdavid/frostyfridays-sf/blob/main/models/challenge_39.sql
-
masking policies revisited. Enjoyed this one
- Solution URL – https://github.com/NMangera/frosty_friday/blob/main/week%2039%20-%20basic%20/CLS
Leave a Reply
You must be logged in to post a comment.