Thank you for clarifying this point.
And yes of course grantor, sorry for the confusion.

Regards,

Fabrice




On Mon, Aug 4, 2025 at 4:30 PM Tom Lane <t...@sss.pgh.pa.us> wrote:

> Fabrice Chapuis <fabrice636...@gmail.com> writes:
> > 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;
>
> > why the grantee is postgres?
>
> You mean "grantor", no?  When a superuser does grant/revoke on some
> object, it's recorded as though the object owner issued the command.
> And postgres is the owner of the pg_statistic table.
>
>                         regards, tom lane
>

Reply via email to