Re: [GENERAL] What user to defaults execute as?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [GENERAL] What user to defaults execute as?
Дата
Msg-id 21202.1036250060@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [GENERAL] What user to defaults execute as?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: [GENERAL] What user to defaults execute as?  (Peter Eisentraut <peter_e@gmx.net>)
Список pgsql-hackers
I said:
> And I have not yet been able to think of a concrete case where the
> existing behavior (execute as calling user) is better.

Okay, I've thought of one: consider the situation where you want to
label each row in a table with the ID of the user who inserted it.
Right now, you can do...,who    name    default current_user,...
or for greater security use a trigger to set the column value.
This will stop working if defaults and triggers run as the table
owner.  (You could maybe use session_user instead, but it's not
clear that that's the right thing if the user is calling setuid
functions that do things on his behalf.)

However this is only one example; I still think Bruno's got a good
argument.
        regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: move 0 behaviour
Следующее
От: Bruno Wolff III
Дата:
Сообщение: Re: [GENERAL] What user to defaults execute as?