Skip to main content
edited tags
Link
Hannah Vernon
  • 70.5k
  • 22
  • 177
  • 321
Source Link

Create user to monitor database activity on Postgres

Postgres 9.3 Debian 7

I want to create a monitor user called monitor that the only permission is to run queries to monitor all the database activity. I created the user and it can select from pg_stat_activity, the problem is that it only sees it's own activity and I want this user to see all users activity.

Is there any special privilege to do that?