Re: Serious Issue in oracle
Date: Sat, 23 Jan 2010 09:38:41 +0100
2010/1/23 AMIT VERMA <verma.labs_at_gmail.com>
> I am sharing my yesterday experience with you, below are the details:
> Not able to access the table.
> In a A schema we have 7 tables x1, x2.... x7 which is further join by a
> VIEW y. Other B/C schema access the y to get the records.
> *ROOT CASUSE:*
> ** :( not able to locate, no error in the alert log, statistics are
> uptodate. Oracle Version is 10g Standard with RHEL update 8.
> Any Suggestions...
i've one, try to explain better what you can't do :) anyway, are you sure that all grants necessary are put in place? remember that each time that you recreate an object, even with the same name, the grants must be reappliedReceived on Sat Jan 23 2010 - 02:38:41 CST