Why is EXECUTE granted to PUBLIC for all routines?

Поиск
Список
Период
Сортировка
От Jacek Trocinski
Тема Why is EXECUTE granted to PUBLIC for all routines?
Дата
Msg-id CAPBN_=npERDpVuvJ63-7gn8PCGPCu_7q0DTwaURg8Of+7a7M+Q@mail.gmail.com
обсуждение исходный текст
Ответы Re: Why is EXECUTE granted to PUBLIC for all routines?
Список pgsql-hackers
Hi,

The default behavior on Postgres is to grant EXECUTE to PUBLIC on any
function or procedure that is created.

I feel this this is a security concern, especially for procedures and
functions defined with the "SECURITY DEFINER" clause.

Normally, we don’t want everyone on the database to be able to run
procedures or function without explicitly granting them the privilege
to do so.

Is there any reason to keep grant EXECUTE to PUBLIC on routines as the default?

Best,
Jacek Trocinski



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