"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.
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
"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.