Re: Transaction prevention - Mailing list pgsql-general

From Tom Lane
Subject Re: Transaction prevention
Date
Msg-id 1344584.1596068614@sss.pgh.pa.us
Whole thread Raw
In response to Transaction prevention  (Steve Baldwin <steve.baldwin@gmail.com>)
Responses Re: Transaction prevention
List pgsql-general
Steve Baldwin <steve.baldwin@gmail.com> writes:
> If I have a user that is restricted to select access (only) on a single
> table, is there any way to prevent that user from starting a transaction?

No, but maybe setting statement_timeout and/or
idle_in_transaction_session_timeout for that user would be helpful
(cf ALTER USER ... SET ...).

            regards, tom lane



pgsql-general by date:

Previous
From: Steve Baldwin
Date:
Subject: Transaction prevention
Next
From: Steve Baldwin
Date:
Subject: Re: Transaction prevention