I agree about the usefulness of including those statements that “technically-only-need-to-be-run-once” in the on-run-ends or post-hooks so everyone can see what needs to be run to make everything work.
Incredible response, @claire, that answers all my question, and I think it also indirectly taught me that maybe I actually don’t need to grant privileges in dev at all (e.g. when I’m trying out new models) because, as the user that made the table/view, I don’t have to grant myself privileges on it. (a duh moment!) I think that’s where I was stuck on for a while, thinking I also had to do grant statements in dev (as long as nobody else needs to look at my dev schema).
THANK YOU!