Re: fragmented sysauth$ table
From: Jonathan Lewis <jlewisoracle_at_gmail.com>
Date: Thu, 29 Apr 2021 10:55:37 +0100
Message-ID: <CAGtsp8n=pp0XsEy0G54LRPeGbQ-fBCAodJbMCA5Ty5ggjRf_+Q_at_mail.gmail.com>
Date: Thu, 29 Apr 2021 10:55:37 +0100
Message-ID: <CAGtsp8n=pp0XsEy0G54LRPeGbQ-fBCAodJbMCA5Ty5ggjRf_+Q_at_mail.gmail.com>
The irony of that, Andrew, is that this might be the (back-ported) fix to
the bug.
The query is probably part of the process of generating a list of all the
privileges that the user acquires through the role set.
Regards
Jonathan Lewis
On Thu, 29 Apr 2021 at 10:42, Andy Sayer <andysayer_at_gmail.com> wrote:
> Isn’t this bug 29796335? It’s fixed in 19.9.
>
> Not sure what the bug fix entails, but I imagine there’s no reason for
> this query to fire for set role.
>
> Thanks,
> Andy
>
>>
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Apr 29 2021 - 11:55:37 CEST