Thread: Revoking permission on view pg_prepared_xacts

Revoking permission on view pg_prepared_xacts

From
Ondrej Chaloupka
Date:
Hi,

I would like know whether there is some way how to revoke permission for doing recovery (showing prepared transactions
andworking 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'tdo recovery stuff? 

Is there some way how to achieve that?

Thank you for any idea
Ondrej