Disabling START TRANSACTION for a SuperUser

From: rajan <vgmonnet(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Disabling START TRANSACTION for a SuperUser
Date: 2015-10-27 10:25:31
Message-ID: 1445941531850-5871630.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Craig Ringer 2015-10-27 12:23:02 Re: Disabling START TRANSACTION for a SuperUser
Previous Message Shulgin, Oleksandr 2015-10-27 08:42:56 Re: Patch: Implement failover on libpq connect level.