Hi,
I would like know whether there is some way how to revoke permission for doing recovery (showing prepared transactions and working with them) for a user?
I've tried someting like
revoke all on pg_catalog.pg_prepared_xacts from public;
and
revoke all on function pg_prepared_xacts from public;
but this does not work (at least for me).
My intention is to have user which could work with xa - doing commit as being part of a global transaction but which can't do recovery stuff?
Is there some way how to achieve that?
Thank you for any idea
Ondrej