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

--000000000000fc2494064daa268c
Content-Type: text/plain; charset="UTF-8"

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.

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

On Sunday, March 22, 2026, Edwin UY &lt;<a href=3D"mailto:edwin.uy@gmail.co=
m">edwin.uy@gmail.com</a>&gt; wrote:<blockquote class=3D"gmail_quote" style=
=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir=
=3D"ltr"><div><span style=3D"font-family:monospace">Is the resultset from t=
hese queries has_table_privilege and information_schema.role_table_<wbr>gra=
nts supposed to match?</span></div><div></div></div></blockquote><div><br><=
/div><div>No.</div><div><br></div><div>The function performs inherits resol=
ution and you specify an anchor role.=C2=A0 The view restricts itself to th=
e logged in role and just reports actual rows created in the database (i.e.=
, the things granted and revoked).</div><div><br></div><div>David J.</div><=
div><br></div>

--000000000000fc2494064daa268c--