Re: ToDo: possible more rights to database owners - Mailing list pgsql-hackers

2013/7/29 Szymon Guz <mabewlun@gmail.com>:

> On 29 July 2013 11:25, Pavel Stehule <pavel.stehule@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.