I'm in the process of designing a new database for an application. I'd like to be mindful of the security from the start (which should be the norm!). Anyone got a link to a resource describing the best way to use schemas to implement good security?
By using schemas, I mean not just dumping everything under the default dbo schema. Surely there's a schema best practises out there? Can't find it if there is...