On 29 July 2013 13:20, Pavel Stehule <pavel.steh...@gmail.com> wrote:
> 2013/7/29 Szymon Guz <mabew...@gmail.com>: > > On 29 July 2013 11:25, Pavel Stehule <pavel.steh...@gmail.com> wrote: > >> > >> Hello > >> > >> In 9.3 super user can cancel all queries or user can cancel own > sessions. > >> > >> Is possible enhance this possibility to database owners? So owner can > >> cancel or can terminate sessions related to owned databases? > >> > > > > But this means that a db owner could cancel superuser's super important > > database query. Maybe let's make a default that the owner can cancel all > > queries except for superuser's ones. And additionaly a special right that > > superuser can grant it to the db owner, so the owner can cancel even > > superuser's queries? > > I am thinking so owner cannot cancel super user is enough. It allows > simply cancelling and terminating connects where we have more > application roles without superuser rights. > I agree.
