MIME-Version: 1.0
References: 
 <CA+wokJ-OQ9s=gpEpUgxXXa0creC-izJb7Giztc-_0N=9SW40xg@mail.gmail.com>
 <CAKFQuwayy4nnXkOPjMZok2oeXwXygGg82TArzf_ZYodQeGhMmQ@mail.gmail.com>
In-Reply-To: 
 <CAKFQuwayy4nnXkOPjMZok2oeXwXygGg82TArzf_ZYodQeGhMmQ@mail.gmail.com>
From: Edwin UY <edwin.uy@gmail.com>
Date: Mon, 23 Mar 2026 18:27:09 +1300
Message-ID: 
 <CA+wokJ_Shd8m5bxkLLJLnbznkztrhaScbRVsi8_RgfZ-bsjPNw@mail.gmail.com>
Subject: Re: Is the resultset from these queries has_table_privilege and
 information_schema.role_table_grants supposed to match?
To: "David G. Johnston" <david.g.johnston@gmail.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000007d66fc064daa4b86"
Archived-At: 
 <https://www.postgresql.org/message-id/CA%2BwokJ_Shd8m5bxkLLJLnbznkztrhaScbRVsi8_RgfZ-bsjPNw%40mail.gmail.com>
Precedence: bulk

--0000000000007d66fc064daa4b86
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Thank you for the clarification.
I've logged in as the grantor now and am checking.

On Mon, Mar 23, 2026 at 6:17=E2=80=AFPM David G. Johnston <
david.g.johnston@gmail.com> wrote:

> On Sunday, March 22, 2026, Edwin UY <edwin.uy@gmail.com> 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.
>
>

--0000000000007d66fc064daa4b86
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>Thank you for the clarification.=C2=A0<br></div>I&#39=
;ve logged in as the grantor now and am checking.</div><br><div class=3D"gm=
ail_quote gmail_quote_container"><div dir=3D"ltr" class=3D"gmail_attr">On M=
on, Mar 23, 2026 at 6:17=E2=80=AFPM David G. Johnston &lt;<a href=3D"mailto=
:david.g.johnston@gmail.com">david.g.johnston@gmail.com</a>&gt; wrote:<br><=
/div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;bo=
rder-left:1px solid rgb(204,204,204);padding-left:1ex">On Sunday, March 22,=
 2026, Edwin UY &lt;<a href=3D"mailto:edwin.uy@gmail.com" target=3D"_blank"=
>edwin.uy@gmail.com</a>&gt; wrote:<blockquote class=3D"gmail_quote" style=
=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding=
-left:1ex"><div dir=3D"ltr"><div><span style=3D"font-family:monospace">Is t=
he resultset from these queries has_table_privilege and information_schema.=
role_table_grants supposed to match?</span></div><div></div></div></blockqu=
ote><div><br></div><div>No.</div><div><br></div><div>The function performs =
inherits resolution and you specify an anchor role.=C2=A0 The view restrict=
s itself to the logged in role and just reports actual rows created in the =
database (i.e., the things granted and revoked).</div><div><br></div><div>D=
avid J.</div><div><br></div>
</blockquote></div>

--0000000000007d66fc064daa4b86--