Revoking permission on view pg_prepared_xacts

Started by Ondrej Chaloupkaalmost 12 years ago1 messagesgeneral
Jump to latest
#1Ondrej Chaloupka
ochaloup@redhat.com

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