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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
