Re: Grants and Invalidations Question

Guess I'm thinking of stored pl/sql objects invalidation/revalidation vs library cache invalidation of sqls in the cache.

Because what I experienced were a bunch of sessions having contention for a bit when I setup a new role and was only thinking about pl/sql invalidation but forgot about active sessions.

On Tue, Nov 15, 2022 at 11:32 AM Chris Taylor < christopherdtaylor1994_at_gmail.com> wrote:

> Have GRANT statements in Oracle always caused invalidations? If not, when
> did that change?
>
> I know REVOKES cause invalidations but I could have sworn that initial
> GRANTS didn't cause revalidations and I'm wondering if I'm wrong and it's
> always been that way, or if that behavior changed somewhere? (or I'm
> having a Mandela Effect moment.....)
>
> Chris
>
>

--
http://www.freelists.org/webpage/oracle-l