Subject Re: [firebird-support] Grant execute on function.
Author Alexandre Vinhaes - Tecnico - Tecnologia
Hi Mark

Version 3.0.4 MOD is not custom function......it is a built-in function.

Regards.

Alexandre.

Em sex., 22 de nov. de 2019 às 15:38, Mark Rotteveel mark@... [firebird-support] <firebird-support@yahoogroups.com> escreveu:
 

On 22-11-2019 15:10, Alexandre Vinhaes - Tecnico - Tecnologia
alexandre.vinhaes@... [firebird-support] wrote:
> I have a problem here during an update statement that call the function
> MOD. Althougt I have done related grant command "grant execute on
> function MOD to users1" the erro message persists:
>
> no permission for EXECUTE access to function MOD
>
> I´m not able to find out my mistake.

Which Firebird version are you using? And is this the built-in function
MOD (introduced in 2.1), or a custom function? For the built-in
function, you shouldn't need a grant AFAIK, so that could indicate a bug.

Mark
--
Mark Rotteveel