While I was at SOURCE Boston this year I had the opportunity to speak with Lisa Vaas about database user security permissions. Video from this discussion has been posted to the HPIO site:
(Their original post is here)
Also we’ve posted slides from the presentation discussed in the video “What Permissions Does Your Database User REALLY Need?”
A number of people have been reaching out about the sqlpermcalc tool we released so hopefully we’ll be pushing out some updates soon to make the query handling more robust.
dan _at_ denimgroup.com