Re: [firebird-support] Fake error "arithmetic exception, numeric overflow..." on stored procedure or trigger

2018-02-22 Thread marco andreolli dra...@gmail.com [firebird-support]
2018-02-22 16:29 GMT+01:00 Mark Rotteveel m...@lawinegevaar.nl [firebird-support] : > > > On 21-2-2018 12:29, marco andreolli dra...@gmail.com [firebird-support] > wrote: > > Recently I have found the error /arithmetic exception, numeric overflow, > > or string truncation/ > > /string right trunca

Re: [firebird-support] Read only user for Firebird 3.

2018-02-22 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
22.02.2018 20:07, Alexandre Vinhaes - Tecnico - Tecnologia alexandre.vinh...@cipa.com.br [firebird-support] wrote: > I need to have a read only login (read all views and tables) for specifc > application > connection. Some those views executes procedures internally. So, in this > case, select

[firebird-support] Read only user for Firebird 3.

2018-02-22 Thread Alexandre Vinhaes - Tecnico - Tecnologia alexandre.vinh...@cipa.com.br [firebird-support]
Hi ! Let me consult my experienced colleagues. I need to have a read only login (read all views and tables) for specifc application connection. Some those views executes procedures internally. So, in this case, select grant is not enough. In order to have an work arround, I could grant execute pro

Re: [firebird-support] Fake error "arithmetic exception, numeric overflow..." on stored procedure or trigger

2018-02-22 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 21-2-2018 12:29, marco andreolli dra...@gmail.com [firebird-support] wrote: > Recently I have found the error /arithmetic exception, numeric overflow, > or string truncation/ > /string right truncation > At trigger 'X' > / > on different trigger or stored procedure. > The strange thing is

Re: [firebird-support] Fake error "arithmetic exception, numeric overflow..." on stored procedure or trigger

2018-02-22 Thread marco andreolli dra...@gmail.com [firebird-support]
The size is less than 64k... 2018-02-22 3:26 GMT+01:00 Anto Edin Charley antoedinchar...@gmail.com [firebird-support] : > > > Check the size of trigger. Sometimes it show like this if the size reaches > 64k. > > On Feb 21, 2018 21:11, "marco andreolli dra...@gmail.com > [firebird-support]" wrote

Re: [firebird-support] Re: server 2.5.8 deadlocked

2018-02-22 Thread Hamish Moffatt ham...@risingsoftware.com [firebird-support]
On 22/02/18 20:17, hv...@users.sourceforge.net [firebird-support] wrote: ---In firebird-support@yahoogroups.com, wrote : On 13/02/18 17:55, Dmitry Yemanov dimitr@... [firebird-support] wrote: > 13.02.2018 05:07, Hamish Moffatt wrote: > >> I attached gdb and du

[firebird-support] Re: No permission to remote access to database

2018-02-22 Thread hv...@users.sourceforge.net [firebird-support]
---In firebird-support@yahoogroups.com, wrote : > How to add permission to login into security3.fdb? Remote login into security database was intentionally forbidden many years ago by security reasons. Embedded connection still possible. Regards, Vlad

Re: [firebird-support] No permission to remote access to database

2018-02-22 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
22.02.2018 11:15, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] wrote: > How to add permission to login into security3.fdb? Locally you don't need any special permission. Remotely you must edit databases.conf to enable that. -- WBR, SD. -

[firebird-support] No permission to remote access to database

2018-02-22 Thread liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
Hi, How to add permission to login into security3.fdb? regards,Karol Bieniaszewski

Re: [firebird-support] Re: SecurityDatabase in FB3

2018-02-22 Thread liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
And if i understand corectly you can have different users acros databases and different users properties Regards,Karol Bieniaszewski null

Re: [firebird-support] Re: SecurityDatabase in FB3

2018-02-22 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
22.02.2018 6:22, Alexander Tabakov a.taba...@eklektica.com [firebird-support] wrote: > So, generally speaking are there any benefits of embedding the credentials > into the > database - performance, security, other ? You don't need to backup/replicate two databases, one is enough. -- W

Re: [firebird-support] Re: server 2.5.8 deadlocked

2018-02-22 Thread hv...@users.sourceforge.net [firebird-support]
---In firebird-support@yahoogroups.com, wrote : On 13/02/18 17:55, Dmitry Yemanov dimitr@... mailto:dimitr@... [firebird-support] wrote: > 13.02.2018 05:07, Hamish Moffatt wrote: > >> I attached gdb and dumped the state of all threads, which shows every >> one of them is waiting on a mute