easy way to track down which table grant(s) are missing in view definition.

From: Stephens, Chris <chris_stephens_at_admworld.com>
Date: Tue, 23 Dec 2008 10:31:23 -0600
Message-ID: <7070047601C21A4CB387D50AD3661F6E0BA8D33B@050EXCHANGE.research.na.admworld.com>

I'm sure many on this list can sympathize but I was just given a view which is producing a 'table or view does not exist' error. This view is built on top of other views and tables when are then built on top of other views and tables and on and on and on.  

Anyways, I'm having a heck of a time tracking down the offending objects and was wondering if there is an easy way to discover this?  

Thanks for any help!


        This message is intended for the use of the individual or entity to which it is addressed and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If the reader of this message is not the intended recipient or the employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by email reply.

Received on Tue Dec 23 2008 - 10:31:23 CST

Original text of this message