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 wrote:
> Fabrice Chapuis writes:
> > I do the following command when connecting locally with user postgres
> > SET ROLE asuperrole; -- asuperrol
Fabrice Chapuis 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
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.r
