Request a Demo
Home   >   mailing lists

Re: Is the resultset from these queries has_table_privilege and information_schema.role_table_grants supposed to match? - Mailing list pgsql-admin

From David G. Johnston
Subject Re: Is the resultset from these queries has_table_privilege and information_schema.role_table_grants supposed to match?
Date
Msg-id CAKFQuwayy4nnXkOPjMZok2oeXwXygGg82TArzf_ZYodQeGhMmQ@mail.gmail.com
Whole thread Raw
In response to Is the resultset from these queries has_table_privilege and information_schema.role_table_grants supposed to match?  (Edwin UY <edwin.uy@gmail.com>)
Responses Re: Is the resultset from these queries has_table_privilege and information_schema.role_table_grants supposed to match?
List pgsql-admin
Tree view
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.

pgsql-admin by date:

Previous
From: Edwin UY
Date:
Subject: Is the resultset from these queries has_table_privilege and information_schema.role_table_grants supposed to match?
Next
From: Edwin UY
Date:
Subject: Re: Is the resultset from these queries has_table_privilege and information_schema.role_table_grants supposed to match?