public inbox for [email protected]
help / color / mirror / Atom feedFrom: David G. Johnston <[email protected]>
To: Edwin UY <[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: Sun, 22 Mar 2026 22:17:33 -0700
Message-ID: <CAKFQuwayy4nnXkOPjMZok2oeXwXygGg82TArzf_ZYodQeGhMmQ@mail.gmail.com> (raw)
In-Reply-To: <CA+wokJ-OQ9s=gpEpUgxXXa0creC-izJb7Giztc-_0N=9SW40xg@mail.gmail.com>
References: <CA+wokJ-OQ9s=gpEpUgxXXa0creC-izJb7Giztc-_0N=9SW40xg@mail.gmail.com>
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: <CAKFQuwayy4nnXkOPjMZok2oeXwXygGg82TArzf_ZYodQeGhMmQ@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