public inbox for [email protected]
help / color / mirror / Atom feedFrom: Edwin UY <[email protected]>
To: David G. Johnston <[email protected]>
Cc: Pgsql-admin <[email protected]>
Subject: Re: Is the resultset from these queries has_table_privilege and information_schema.role_table_grants supposed to match?
Date: Mon, 23 Mar 2026 18:27:09 +1300
Message-ID: <CA+wokJ_Shd8m5bxkLLJLnbznkztrhaScbRVsi8_RgfZ-bsjPNw@mail.gmail.com> (raw)
In-Reply-To: <CAKFQuwayy4nnXkOPjMZok2oeXwXygGg82TArzf_ZYodQeGhMmQ@mail.gmail.com>
References: <CA+wokJ-OQ9s=gpEpUgxXXa0creC-izJb7Giztc-_0N=9SW40xg@mail.gmail.com>
<CAKFQuwayy4nnXkOPjMZok2oeXwXygGg82TArzf_ZYodQeGhMmQ@mail.gmail.com>
Thank you for the clarification.
I've logged in as the grantor now and am checking.
On Mon, Mar 23, 2026 at 6:17 PM David G. Johnston <
[email protected]> wrote:
> On Sunday, March 22, 2026, Edwin UY <[email protected]> wrote:
>>
>> Is the resultset from these queries has_table_privilege and
>> information_schema.role_table_grants supposed to match?
>>
>
> No.
>
> The function performs inherits resolution and you specify an anchor role.
> The view restricts itself to the logged in role and just reports actual
> rows created in the database (i.e., the things granted and revoked).
>
> David J.
>
>
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: Is the resultset from these queries has_table_privilege and information_schema.role_table_grants supposed to match?
In-Reply-To: <CA+wokJ_Shd8m5bxkLLJLnbznkztrhaScbRVsi8_RgfZ-bsjPNw@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox