Disabling START TRANSACTION for a SuperUser

Поиск
Список
Период
Сортировка
От rajan
Тема Disabling START TRANSACTION for a SuperUser
Дата
Msg-id 1445941531850-5871630.post@n5.nabble.com
обсуждение исходный текст
Ответы Re: Disabling START TRANSACTION for a SuperUser  (Craig Ringer <craig@2ndquadrant.com>)
Список 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.



В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Shulgin, Oleksandr"
Дата:
Сообщение: Re: Patch: Implement failover on libpq connect level.
Следующее
От: Craig Ringer
Дата:
Сообщение: Re: Disabling START TRANSACTION for a SuperUser