From: | Ondrej Chaloupka <ochaloup(at)redhat(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Revoking permission on view pg_prepared_xacts |
Date: | 2014-05-20 13:55:10 |
Message-ID: | 1732376753.8565143.1400594110053.JavaMail.zimbra@redhat.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Sergio Mior D&T | 2014-05-20 15:43:03 | D&T Italia : Time Travel : new development : first release |
Previous Message | Victor Yegorov | 2014-05-20 12:38:29 | Re: Constraint exclusion for timestamp expression |