Re: [firebird-support] Application users and FireBird users

2012-12-11 Thread André Knappstein
However, there is also a pseudo-role named PUBLIC that you can grant rights to and all users get the privileges granted to PUBLIC. plus there was a (bug/feature?) in 1.5 where any user who logged in with lower case username but with the correct password has been granted PUBLIC

[firebird-support] Migration from 2.5.1 to 2.5.2

2012-12-11 Thread Matheus Degiovani
Hello, When performing the migration from FB 2.5.1 to 2.5.2, can I use the gbak.exe from 2.5.2 for both operations (backup and restore) or should I backup with the 2.5.1 gbak and restore with the 2.5.2 gbak? Thanks. -- Matheus Degiovani Gigatron Software e Treinamentos Ltda. (18) 3642-9008

[firebird-support] Re: Migration from 2.5.1 to 2.5.2

2012-12-11 Thread arda
I remember I first updated the firebird engine and than used gbak. No problems. --- In firebird-support@yahoogroups.com, Matheus Degiovani matheus@... wrote: Hello, When performing the migration from FB 2.5.1 to 2.5.2, can I use the gbak.exe from 2.5.2 for both operations (backup and

[firebird-support] FB 2.5.2 trigger doesn't fire

2012-12-11 Thread Rick Debay
CREATE EXCEPTION E ''; CREATE TRIGGER T_TEST_BEFORE FOR T ACTIVE BEFORE INSERT POSITION 0 AS begin EXCEPTION E 'TEST BEFORE'; End CREATE TRIGGER T_TEST_AFTER FOR T ACTIVE AFTER INSERT POSITION 0 AS begin EXCEPTION E 'TEST AFTER'; End Inserting into the table T does not throw an exception.