Re: Terminate connections using non-superuser

[Naveen Kumar <naveenchowdaryon@xxxxxxxxx>]

Yes, non-superuser can do this. but user should have privilege to this.

GRANT pg_signal_backend TO user; 

Thanks & Regards,

Naveen Kumar .M,

Sr. PostgreSQL Database Administrator,

Mobile: 7755929449.

My attitude will always be based on how you treat me. 

On Wed, Aug 2, 2017 at 6:06 PM, amandeep singh <singh_a@xxxxxxx> wrote:

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