User Objects are decompiled
555704May 14 2007 — edited May 15 2007Hi all,
I have an unusual situation regarding one of our apps.
We're running Oracle10g Database, and our app uses more users to hold it's business.
Because of data "viewbility" under different users we have created different synonims for some sequences, views or different procedures/packages so they can be run/view under different users. The problem is that some of our packages/views/synonims keeps getting invalidated from time to time and we can't find a reason why...
Can someone point me in the right direction for this?
We compiled all user objects, but after a period one of the synonims is again, invalid so the app is sort of unusable
Thanks in advance.