"In SQL Server everyone could see everything, so everyone could potentially delete anything
We made the conscious decision to create a schema for each function so they have a dedicated place to write their tables. Analysts then grant access to tables they want to share because everyone shouldn’t have access to everything"
That's a critique of your original database design, but it reads like a limitation of the SQL platform.
I'd love to get my teeth into some cloud database projects but all the companies I work on cannot allow their data to be hosted on the cloud and insist on in house SQL servers segregated from the internet.
We're a place where coders share, stay up-to-date and grow their careers.
We strive for transparency and don't collect excess data.