Re: How to create read-only view on 9.3

Поиск
Список
Период
Сортировка
От Andrew Dunstan
Тема Re: How to create read-only view on 9.3
Дата
Msg-id 520A78A1.4030504@dunslane.net
обсуждение исходный текст
Ответ на Re: How to create read-only view on 9.3  (Hannu Krosing <hannu@2ndQuadrant.com>)
Список pgsql-hackers
On 08/13/2013 01:33 PM, Hannu Krosing wrote:

>>
>> In any case, using permissions is a somewhat leaky bandaid, since
>> superusers have overriding access privileges anyway. A better way
>> to do what the OP wants might be to have a view trigger that raises an
>> exception.
> Superuser can easily disable or drop the trigger as well.

That's true, but it requires positive action to do so. Thus the trigger 
can give you some protection in cases of stupidity, if not cases of malice.

cheers

andrew



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: How to create read-only view on 9.3
Следующее
От: Tom Lane
Дата:
Сообщение: Release schedule for PG 9.3