Re: Is it possible to stop sessions killing eachother when they all authorize as the same role?

Mladen Gogala <gogala.mladen@gmail.com> writes:
> Tom, I did the same thing on 14.5, and it behaves as Bryn alleges:

Looks to me like you made the same mistake as Bryn.  You
revoked the permission in the postgres database:

> postgres=# select proacl from pg_proc where proname = 
  ^^^^^^^^
> 'pg_terminate_backend';
>          proacl
> -----------------------
>   {postgres=X/postgres}
> (1 row)

> mgogala@umajor ~]$ psql -U scott
> Password for user scott: psql (14.5) 
> Type "help" for help.
> scott=> select pid from pg_stat_activity where 
  ^^^^^

... and here you're testing the permission in the "scott" database.

            regards, tom lane