Postgres Pro
Downloads
Home   >   mailing lists

Re: [ADMIN] Terminate connections using non-superuser - Mailing list pgsql-admin

From Scott Mead
Subject Re: [ADMIN] Terminate connections using non-superuser
Date
Msg-id CAKq0gvKC7-P4Tv-Dtm+eJFm+6jEw11dsi30YNEpjabvOwmF5yw@mail.gmail.com
Whole thread Raw
In response to [ADMIN] Terminate connections using non-superuser  (amandeep singh <singh_a@live.in>)
List pgsql-admin
Tree view

On Wed, Aug 2, 2017 at 8:36 AM, amandeep singh <singh_a@live.in> 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?



Create a wrapper function, my_pg_stat_activity() or my_pg_terminate_backend()

on creation, use 'security definer' 
 

Postgres Version :PostgreSQL9.6

 


Thanks and Regards:
Amandeep Singh



--
--
Scott Mead
Sr. Architect
OpenSCG

pgsql-admin by date:

Previous
From: Naveen Kumar
Date:
Subject: Re: [ADMIN] Terminate connections using non-superuser
Next
From: Pankaj Arora
Date:
Subject: [ADMIN] PostgreSQL 9.3 Uninstall error - Windows 2012