Re: set role issue

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 <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Fabrice Chapuis <fabrice636861(at)gmail(dot)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
>