Try
Home   >   mailing lists

set role issue - Mailing list pgsql-hackers

From Fabrice Chapuis
Subject set role issue
Date
Msg-id CAA5-nLDJs1BAD8B3tZm7ewrWSTgM7qSYFnwax=0BcXu9ps16-g@mail.gmail.com
Whole thread Raw
Responses Re: set role issue
List pgsql-hackers
Tree view
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

pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: CREATE PUBLICATION with 'publish_generated_columns' parameter specified but unassigned
Next
From: 矫顺田
Date:
Subject: Re: GB18030-2022 Support in PostgreSQL