Terminate connections using non-superuser

From: amandeep singh <singh_a(at)live(dot)in>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Terminate connections using non-superuser
Date: 2017-08-02 12:36:05
Message-ID: MA1PR01MB0748C1F4891FAC8DFB843E6480B00@MA1PR01MB0748.INDPRD01.PROD.OUTLOOK.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi All

I have a requirement where I need a non-superuser who can view (pg_stat_activity) and terminate (pg_terminate_backend) connections of other users. Is it possible to give such privileges to non-superuser?

Postgres Version :PostgreSQL9.6

Thanks and Regards:
Amandeep Singh

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Naveen Kumar 2017-08-02 12:45:27 Re: Terminate connections using non-superuser
Previous Message Albe Laurenz 2017-08-02 06:43:10 Re: phantom rights