The reason: we all have bad deployment practices.
By mockingly arguing that we all do the worst deployments possible, I can (hopefully) inspire people to change their bad habits.
Here are my notes and slide deck:Permalink
During SQL Saturday 92 I was asked about how to do easily manage permissions. I am assuming that systems are using application-specific database roles. Database roles are great because they are login-independent and can work in any environment.
I have found that two approaches tend to work quite well.
I have written a sample ‘complete list’ script, below, that defines permissions in XML, which can then be audited or applied to a database.Permalink