Thanks for your response.

You are right that care needs to be taken in the authentication layer.

And yes, developing SQL in a shared environment is a complex task and needs to be accompanied by proper tooling.