Warning: this post involves me standing on a soapbox: it’s going to be a bit of a rant/preach about why everyone should care about security! Starting with….
When I talk to my developer colleagues, very few of them realise that database schemas are actually a security feature of SQL Server. They also don’t appreciate that security in a database needs to be designed, it doesn’t just happen. If it’s considered from an early point in the design of the database and application, then it will be much easier to implement and cause them less headaches in the long run when they ask me for some elevated permission or other and I say “no, because….” and start explaining about ownership chaining and a whole bunch of other security related stuff that makes them roll their eyes at me…. ahem, I digress.