set role issue

From: Fabrice Chapuis <fabrice636861(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: set role issue
Date: 2025-08-04 09:09:11
Message-ID: CAA5-nLDJs1BAD8B3tZm7ewrWSTgM7qSYFnwax=0BcXu9ps16-g@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

I do the following command when connecting locally with user postgres

SET ROLE asuperrole; -- asuperrole has superuser privilege
GRANT SELECT ON pg_statistic TO test_role;

SELECT
grantee,
grantor,
table_catalog,
table_schema,
table_name,
privilege_type
FROM
information_schema.role_table_grants
WHERE
table_name = 'pg_statistic'

test_role| postgres | db012d00 | pg_catalog | pg_statistic |
SELECT

why the grantee is postgres?

Thanks in advance for clarification

Regards,

Fabrice

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message 矫顺田 2025-08-04 09:27:15 Re: GB18030-2022 Support in PostgreSQL
Previous Message Amit Kapila 2025-08-04 09:01:03 Re: CREATE PUBLICATION with 'publish_generated_columns' parameter specified but unassigned