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
