Re: Is the resultset from these queries has_table_privilege and information_schema.role_table_grants supposed to match?

From: Edwin UY <edwin(dot)uy(at)gmail(dot)com>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Is the resultset from these queries has_table_privilege and information_schema.role_table_grants supposed to match?
Date: 2026-03-23 05:27:09
Message-ID: CA+wokJ_Shd8m5bxkLLJLnbznkztrhaScbRVsi8_RgfZ-bsjPNw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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 <
david(dot)g(dot)johnston(at)gmail(dot)com> wrote:

> On Sunday, March 22, 2026, Edwin UY <edwin(dot)uy(at)gmail(dot)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.
>
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Mauricio Martini 2026-03-23 13:02:42 Technical validation on altering atttypmod for numeric column in PostgreSQL
Previous Message David G. Johnston 2026-03-23 05:17:33 Re: Is the resultset from these queries has_table_privilege and information_schema.role_table_grants supposed to match?