Re: Serious Issue in oracle
Date: Sat, 23 Jan 2010 14:50:11 +0530
All grants are given. Eariler we were able to access it however index & table are Valid. When there was no solution to resolve it we have rebooted the database. And thereafter problem resolves, we again access the table. Its Strange!
On Sat, Jan 23, 2010 at 2:08 PM, David Ballester <ballester.david_at_gmail.com>wrote:
> 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 reapplied
-- Amit Verma v.amit84_at_skype.com "Winning takes talent but it takes character to keep winning" -- http://www.freelists.org/webpage/oracle-lReceived on Sat Jan 23 2010 - 03:20:11 CST