Revoking permission on view pg_prepared_xacts - Mailing list pgsql-general

From Ondrej Chaloupka
Subject Revoking permission on view pg_prepared_xacts
Date
Msg-id 1732376753.8565143.1400594110053.JavaMail.zimbra@redhat.com
Whole thread Raw
List pgsql-general
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


pgsql-general by date:

Previous
From: Victor Yegorov
Date:
Subject: Re: Constraint exclusion for timestamp expression
Next
From: Sergio Mior D&T
Date:
Subject: D&T Italia : Time Travel : new development : first release