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
6 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
-
This code provides 2 versions, one with a fixed amount of * symbols and one with * corresponding to each character preceding the @ symbol.
- Solution URL – https://github.com/GerganaAK/FrostyFridays/blob/main/Week%2039%20-%20Basic
Leave a Reply
You must be logged in to post a comment.