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. Regards Pavel > > szymon -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
