Mladen Gogala <gogala(dot)mladen(at)gmail(dot)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(at)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