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

Reply via email to