ПРЕДОСТАВЬТЕ/ОТМЕНИТЕ на функциях

Question

Основы Защиты Microsoft свободны, пока у Вас есть действительная лицензия Windows.

1

postgresql permissions

задан Bart Friederichs 22 February 2013 в 14:30

Ссылка

1 ответ

score 2 · Answer 1 · 3 December 2019 в 21:36

This is probably because public has execute privilege on your function (it's the default).

Try this:

revoke execute on function getid(text,text)  from public;

and recheck the result of has_function_privilege.

For public to not get this privilege on newly created functions, you may change the default with:

ALTER default privileges revoke execute on functions from public;