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

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Edwin UY <edwin(dot)uy(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:17:33
Message-ID: CAKFQuwayy4nnXkOPjMZok2oeXwXygGg82TArzf_ZYodQeGhMmQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Edwin UY 2026-03-23 05:27:09 Re: Is the resultset from these queries has_table_privilege and information_schema.role_table_grants supposed to match?
Previous Message Edwin UY 2026-03-23 05:00:14 Is the resultset from these queries has_table_privilege and information_schema.role_table_grants supposed to match?