I'll be different and go with 1. I'm assuming that Mike is the owner of the view ( MikesSchema.ContactsFormatted ) and it can be assumed he had permissions to view data from the Contacts table (well, at least I hope so). Therefore, since Mike had sufficient permissions to create the view and view the data, I would think that Paul would "inherit" some