Re: SQL not working in 10g Release 2

From: hans <hansF_at_telus.net>
Date: Thu, 12 Jan 2006 06:21:17 GMT
Message-Id: <pan.2006.01.12.06.20.58.547000@telus.net>

On Tue, 10 Jan 2006 22:33:30 -0800, murali wrote:

>
> I have migrated to 10g release 2 from release 1 few days back. I am
> finding a lot of issues currently in R2. One major problem is that one
> SQL is working when I login as the schema user, but when I try to run
> it by login as a different user it is not executing.

Hmmmm - haven't looked thru the other threads (yet), but I'd like verification:

when table owner uses query, it works.
when non-table owner uses query, it doesn't work.

If true, what doesn't work? Are you getting specific messages, or have you, or someone, possibly enabled VPD [row-level] policies? Received on Thu Jan 12 2006 - 00:21:17 CST