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).
From:
"David G. Johnston" Date: Subject:
Re: Is the resultset from these queries has_table_privilege and information_schema.role_table_grants supposed to match?
