RE: easy way to track down which table grant(s) are missing in view definition.
Date: Tue, 23 Dec 2008 11:47:38 -0500
Message-ID: <21469B88E0EA11498818517F210335310455BB49@EPRI17P32001A.csfb.cs-group.com>
Query DBA_DEPENDENCIES.
Paul Baumgartel
CREDIT SUISSE
Information Technology
Prime Services Databases Americas
One Madison Avenue
New York, NY 10010
USA
Phone 212.538.1143
paul.baumgartel_at_credit-suisse.com
www.credit-suisse.com
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mercadante, Thomas F
(LABOR)
Sent: Tuesday, December 23, 2008 11:36 AM
To: chris_stephens_at_admworld.com; oracle-l_at_freelists.org
Subject: RE: easy way to track down which table grant(s) are missing in
view definition.
Chris,
If your view uses more than one table or view, you could always start with creating a simple view including each object one at a time to see which one throws the error. These would be throw away views just to debug what security access you are missing.
Make sense?
Tom
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Stephens, Chris
Sent: Tuesday, December 23, 2008 11:31 AM
To: oracle-l_at_freelists.org
Subject: easy way to track down which table grant(s) are missing in view
definition.
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!
Chris
CONFIDENTIALITY NOTICE:
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.
Please access the attached hyperlink for an important electronic communications disclaimer:
http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Dec 23 2008 - 10:47:38 CST