Thanks so far.

Ed: I agree with you 1000% about the layering of views. Got truly spaghetti sql to deal with here. I'm working on convincing the powers that be that we should create a database with the "answers" pre-populated. First step towards a data warehouse.

Grant: Please continue writing books!

Haven't yet found any evidence of filtering based on username, but I'm still digging.

sqlslacker: No resource governing implemented on any resources or any users.