I am completely lost when it comes to this project. The hints aren’t helpful at all, and neither are the lesson or the cheatsheets available. I’m specifically having trouble with the “Granting a Publisher Access to Analytics” portion of the project. The worst part is that there’s no accompanying video to help out the learners when they do get stuck.
Nice first post! This was really helpful where the instructions were a bit hard to follow. For future reference you can use the small </> button in the editor and then type or paste the code into the code-block.
People that are having trouble with the end problems, The phrasing on what is desired for the Row Level Security question is incorrect. I believe they desire you to set the owner = current_user. At least my code worked appropriately when I did that instead of publisher = current_user. Hopefully helpful.
I know this is from a while back, but I hope this helps someone in the future. I believe there is an error in the wording of the steps.
The analytics.downloads table does not have a “publisher” column, which is why the “publisher” does not exist error occurs. I think the actual wording of the step should be:
“Create and enable policy that says that the current_user must be the owner of the dataset to SELECT .”
My solution code:
CREATE POLICY privacy ON analytics.downloads FOR SELECT
TO publishers USING (owner=current_user);
ALTER TABLE analytics.downloads ENABLE ROW LEVEL SECURITY;
I find the backend development class to be full of bugs and miscommunications. Very frustrating after having such a positive experience with the front end development class, for the most part (some areas near the end were a little messy).
So forgive me if this is simply my ignorance, but when was this covered in the lesson…? Because I have literally copypasted notes at every stage and SELECT ON ALL TABLES is mentioned exactly nowhere - so I’m confused as to why it’s suddenly asked for with nothing even mentioned about it in the hint
This project seems incredibly badly explained and it’s far from the first time