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

From Szymon Guz
Subject Re: ToDo: possible more rights to database owners
Date
Msg-id CAFjNrYvuNjTG92hrOHSC=h7Y9vj-i=nJr-rzbi1b8d5J41+jLw@mail.gmail.com
Whole thread Raw
In response to Re: ToDo: possible more rights to database owners  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-hackers



On 29 July 2013 13:20, Pavel Stehule <pavel.stehule@gmail.com> wrote:
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.

I agree. 

pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: Bison 3.0 updates
Next
From: Amit Kapila
Date:
Subject: Re: ALTER SYSTEM SET command to change postgresql.conf parameters (RE: Proposal for Allow postgresql.conf values to be changed via SQL [review])