Re: Serious Issue in oracle

From: David Ballester <ballester.david_at_gmail.com>
Date: Sat, 23 Jan 2010 09:38:41 +0100
Message-ID: <6a29f8b1001230038o69f4e01dl5182bcb03ba8edbb_at_mail.gmail.com>

2010/1/23 AMIT VERMA <verma.labs_at_gmail.com>

> All,
>
> I am sharing my yesterday experience with you, below are the details:
>
> *
> ISSUE:
> *
> Not able to access the table.
> **
> *DEPLOYMENT:*
> 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 reapplied

--
http://www.freelists.org/webpage/oracle-l

Received on Sat Jan 23 2010 - 02:38:41 CST