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?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Cryptohash OpenSSL error queue in FIPS enabled builds
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Why is EXECUTE granted to PUBLIC for all routines?