Postgres Pro
Downloads
Home   >   mailing lists

Disabling START TRANSACTION for a SuperUser - Mailing list pgsql-hackers

From rajan
Subject Disabling START TRANSACTION for a SuperUser
Date
Msg-id 1445941531850-5871630.post@n5.nabble.com
Whole thread Raw
Responses Re: Disabling START TRANSACTION for a SuperUser  (Craig Ringer <craig@2ndquadrant.com>)
List pgsql-hackers
Tree view 
Hi,

I have created a readonly user by executing the following statements,
CREATE USER backupadm SUPERUSER  password 'mypass';
ALTER USER backupadm set default_transaction_read_only = on;

But the backupadm user is able to create/update table when using START
TRANSACTION READ WRITE and then COMMIT;

Is there any way to block/disabling an User from running Transactions?

Thanks in advance.



--
View this message in context: http://postgresql.nabble.com/Disabling-START-TRANSACTION-for-a-SuperUser-tp5871630.html
Sent from the PostgreSQL - hackers mailing list archive at Nabble.com.

pgsql-hackers by date:

Previous
From: "Shulgin, Oleksandr"
Date:
Subject: Re: Patch: Implement failover on libpq connect level.
Next
From: Craig Ringer
Date:
Subject: Re: Disabling START TRANSACTION for a SuperUser