Best practice to create a read-only user?

Поиск
Список
Период
Сортировка
От matthias ritzkowski
Тема Best practice to create a read-only user?
Дата
Msg-id 20130503100302.0000043e@unknown
обсуждение исходный текст
Ответы Re: Best practice to create a read-only user?
Re: Best practice to create a read-only user?
Список pgsql-admin
Hello,

Usually I would

create user uuu password 'ppp';
GRANT usage on schema zzz to uuu;
GRANT select on all tables in schema zzz to uuu;


But just this morning someone used
create user uuu password 'ppp';
alter user uuu set default_transaction_read_only = on;
GRANT select on all tables in schema zzz to uuu;

So I only added the grant usage and it worked fine.
What do people use day to day?

I had frankly never explored the default_transaction_read_only
parameter ...


--

regards
Matthias Ritzkowski
-marlinmobile-

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

Предыдущее
От: Nghia Truong
Дата:
Сообщение: Problem: pg_hba.conf is automatically rewritten every day
Следующее
От: "Marcelo Verissimo"
Дата:
Сообщение: RES: Problem: pg_hba.conf is automatically rewritten every day