Re: Grants and Invalidations Question

Hi Chris,

AFAIK, both grant and revoke always caused cursors to be invalid and required a hard parsing. Privilege verification is part of the parsing process.

On Tue, 15 Nov 2022 at 13:33 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
>
> --
[image: LORE DATA]
Franky Weber Faust

Consultor de Banco de Dados | LORE DATA
Oracle ACE ♠️
Fone: *47 99125 2714*
Email: franky_at_loredata.com.br
loredata.com.br

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