Re: same query, different parsing users, different plans ...

From: stephen O'D <>
Date: Fri, 6 Jun 2008 04:08:42 -0700 (PDT)
Message-ID: <>

> I will update again if this fixes it.

Giving the 'merge any view' privilege to the non-object owners fixed this problem.

Personally I think this is a bug waiting to happen, I mean who would possibly have guessed of this sort of behaviour? The merge any view privilege is a feature to enhance security, but the fact that plans generated by user_1 are sub-optimal because of it, and then SHARED is totally unexpected behaviour. Received on Fri Jun 06 2008 - 06:08:42 CDT

Original text of this message