> On Sep 13, 2022, at 11:39, Bryn Llewellyn <bryn@yugabyte.com> wrote:
>
> What are you seeing that I'm failing to?
It works correctly for me, on MacOS:
swift-239:~ xof$ psql
psql (14.5)
Type "help" for help.
xof=# create user r1;
CREATE ROLE
xof=# revoke execute on function pg_terminate_backend from r1;
REVOKE
xof=#
\q
swift-239:~ xof$ psql -U r1 xof
psql (14.5)
Type "help" for help.
xof=> select pg_terminate_backend(123);
ERROR: permission denied for function pg_terminate_backend
xof=>