[firebird-support] Grant execute on function.
2019-11-22
Thread
Alexandre Vinhaes - Tecnico - Tecnologia alexandre.vinh...@cipa.com.br [firebird-support]
Hi all, 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. Anyone could
Re: [firebird-support] Grant execute on function.
Did you reconnect after grant?Regards,Karol Bieniaszewski null
Re: [firebird-support] Grant execute on function.
2019-11-22
Thread
Alexandre Vinhaes - Tecnico - Tecnologia alexandre.vinh...@cipa.com.br [firebird-support]
Hi Karol. Yes, i do. Atenciosamente. Alexandre Vinhaes Administrador de Banco de Dados - Tecnologia +55 21 2196-5206 <+55%2021%202196-5206> Em sex., 22 de nov. de 2019 às 12:31, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] < firebird-support@yahoogroups.com> escreveu: > > > Di
Re: [firebird-support] Grant execute on function.
On 22-11-2019 15:10, Alexandre Vinhaes - Tecnico - Tecnologia alexandre.vinh...@cipa.com.br [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 m
Re: [firebird-support] Grant execute on function.
2019-11-22
Thread
Alexandre Vinhaes - Tecnico - Tecnologia alexandre.vinh...@cipa.com.br [firebird-support]
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 m...@lawinegevaar..nl [firebird-support] escreveu: > > > On 22-11-2019 15:10, Alexandre Vinhaes - Tecnico - Tecnologia > alexandre.vinh...@
ODP: [firebird-support] Grant execute on function.
Is „users1” a user name or role name? If role, then check if user have this role granted and it connect using the role. Regards, Karol Bieniaszewski
Re: [firebird-support] Grant execute on function.
2019-11-22
Thread
Alexandre Vinhaes - Tecnico - Tecnologia alexandre.vinh...@cipa.com.br [firebird-support]
Hi Karol. It is an user. Em sex., 22 de nov. de 2019 às 16:44, Karol Bieniaszewski liviusliv...@poczta.onet.pl [firebird-support] < firebird-support@yahoogroups.com> escreveu: > > > Is „users1” a user name or role name? > > If role, then check if user have this role granted and it connect using
Re: [firebird-support] Grant execute on function.
On 22-11-2019 20:27, Alexandre Vinhaes - Tecnico - Tecnologia alexandre.vinh...@cipa.com.br [firebird-support] wrote: > Version 3.0.4 MOD is not custom function..it is a built-in function. Then as far as I know you shouldn't need to grant anything. I don't think you even can grant anything f