Revoking permission on view pg_prepared_xacts
Started by Ondrej Chaloupkaalmost 12 years ago1 messagesgeneral
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
Import Notes
Reply to msg id not found: 684228740.8549837.1400593955058.JavaMail.zimbra@redhat.com