# Exact permissions need PMM user on Postgresql?

**URL:** <https://forums.percona.com/t/exact-permissions-need-pmm-user-on-postgresql/28270>\
**Category:** PMM 2.x\
**Tags:** postgres, postgresql\
**Created:** [February 5, 2024, 4:13pm UTC](https://forums.percona.com/t/exact-permissions-need-pmm-user-on-postgresql/28270 "2024-02-05T16:13:36Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![igorFA](https://avatars.discourse-cdn.com/v4/letter/i/85f322/32.png) [@igorFA](https://forums.percona.com/u/igorFA)\
**Post date:** [February 5, 2024, 4:13pm UTC](https://forums.percona.com/t/exact-permissions-need-pmm-user-on-postgresql/28270/1 "2024-02-05T16:13:36Z")

</div>

### Description:

The official Percona Monitoring and Management (PMM) documentation suggests creating a PMM user with `WITH SUPERUSER` permission. However, I prefer to avoid granting such extensive permissions. While the PMM agent operates smoothly with basic permissions, I encountered an issue with Query Analytics.

After executing `GRANT SELECT ON pg_stat_statements TO pmm-user` on all databases, I can observe query analytics on the ‘postgres’ system database, but not on other databases.

I’m seeking guidance on whether it’s possible to enable query analytics in PMM without granting superuser permissions to the user.

### Version:

PMM Version: 2.40.0

---

<div class="post-metadata">

**Author:** ![Robert\_Bernier](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/robert_bernier/32/1367_2.png) [@Robert\_Bernier](https://forums.percona.com/u/Robert_Bernier)\
**Post date:** [February 6, 2024, 3:19pm UTC](https://forums.percona.com/t/exact-permissions-need-pmm-user-on-postgresql/28270/2 "2024-02-06T15:19:12Z")

</div>

Hi,

Take a look at the reference documentation regarding [postgres specific roles](https://www.postgresql.org/docs/current/predefined-roles.html) that can be membered to user-defined accounts.

My personal favorite is pg\_monitor.

Hope this helps.