Read only to schema

Поиск
Список
Период
Сортировка
От Łukasz Jarych
Тема Read only to schema
Дата
Msg-id CAGv31odWvR7=_VPR=wVNkK3nNh5EHfEyEuMSUHW0TNFdHVjnXw@mail.gmail.com
обсуждение исходный текст
Ответы RE: Read only to schema
Re: Read only to schema
Список pgsql-general
Hi Guys,

Yesterday i tried all day to figure out system to read only schemas. 

I want to :

1. Create user who can login (user: jaryszek)
2. Create role who can read only data (only watching tables) (role: readonly)
3, Create role who can read all data (inserting, deleting, altering, dropping) (role: readall)

What sqls should i use for this? 
What grants should i add?

And now i am logged as jaryszek

I want to grant myself role read only to schema public (when owner is postgres). 
I want to review tables as views only,
After work i want to grant myself role readall to schema public. 

It is possible? 
Or possible workaround ? 

Best,
Jacek

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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: How to watch for schema changes
Следующее
От: "Charles Clavadetscher"
Дата:
Сообщение: RE: Read only to schema