RE: Trigger with superuser privileges

Поиск
Список
Период
Сортировка
От Edmar Wiggers
Тема RE: Trigger with superuser privileges
Дата
Msg-id NEBBIAKDCDHFGJMLHCKIOEJMCCAA.edmar@brasmap.com
обсуждение исходный текст
Ответ на Trigger with superuser privileges  (Tulio Oliveira <mestredosmagos@marilia.com>)
Список pgsql-general
> Anobody could tell-me how can I make a Trigger thats execute some things
> whith "postgres" superuser privileges (like INSERT INTO a table that the
> user logged in don't have access)

I think triggers should run with table-owner user permissions. That way you
could have a table owned by superuser, who then grants insert/update/delete
privileges to regular users.

But I'm not sure that's how things are done now. Anyone?


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

Предыдущее
От: "Bryan White"
Дата:
Сообщение: Insert where not duplicate
Следующее
От: "Mark Cowlishaw"
Дата:
Сообщение: Re: extra spaces