I'm working with someone whose client says "Yes, we have a data warehouse. But NO you can't be granted access to it."
Technically, can you not create one or more schemas and add views to the schema ( and the other necessary required objects ) so that the outsiders are granted some but not full access and can do their jobs? Yeah, create a security group, add all the contractor users to the group, and go that route... (Or is that just an insane security hole?)
I'm just not in the mood to create a data warehouse from the bits and pieces we've been granted access to. A lot of it doesn't even make much sense, because it's missing the relationships to other tables.
Any suggestions on how to handle a mess like this? Anything I should read?