Hi Remigiusz! On 01/19/2010 08:43 AM, Remigiusz Sokolowski wrote:
Hi,
[...]
Anybody hit something like it or is able to explain this? Best regards Remigiusz Sokolowski
Could this be caused by a FGAC policy? You know where it rewrites the query "behind the scene". This feature is also known as virtual private database or VPD.
Reference: http://download.oracle.com/docs/cd/B19306_01/network.102/b14266/politips.htm#CHDJGFDC Hope this helps, Martin -- Martin Bach OCM 10g http://martincarstenbach.wordpress.com -- //www.freelists.org/webpage/oracle-l