Azure superuser role granted a select permission to some roles -pg_stat_statements and pg_buffercache

Question

Why are some of my roles assigned to all tables in my databases where the grantor is azure_superuser, and what can be the causes? The tables pg_stat_statements and pg_buffercache

PS - Based on common issues that we have seen from customers and other sources, we are posting these questions to help the Azure community

Answer 1

Greetings!

This behavior is expected and by design. The Azure superuser role is responsible for managing system-level operations and maintenance tasks in Azure Database for PostgreSQL. The tables pg_stat_statements and pg_buffercache are system tables that are not created by the customer. These tables require superuser privileges to grant permissions for monitoring and performance tuning purposes. Therefore, seeing the azure_superuser as the grantor of permissions on these tables is normal and necessary for the proper functioning of the database system.

 

• pg_stat_statements
• pg_buffercache

 

Hope this helps. If you have any follow-up questions, please let me know. I would be happy to help.

 

Please do not forget to  "up-vote" wherever the information provided helps you, as this can be beneficial to other community members.

Regards

Geetha