Subject Odp: [firebird-support] Procedures and Triggers missing
Author liviuslivius@poczta.onet.pl
Post date 2015-06-25T05:22:36Z
Hi,
Do you have sysdba and default masterkey? If yes, then change it. Maybe someone else is connecting to your database without permission and do some strange work

Regards,
Karol Bieniaszewski

----- Reply message -----
Od: "Chris Valentine chrisvalentinemail@... [firebird-support]" <firebird-support@yahoogroups.com>
Do: <firebird-support@yahoogroups.com>
Temat: [firebird-support] Procedures and Triggers missing
Data: śr., cze 24, 2015 22:20


 

We have a Firebird 1.5.6 database that we have been using for several years.  Many clients use it, there are rarely any issues.

One particular client, suddenly is missing triggers and procedures, seemingly with no cause.

Procedures get replace with:   BEGIN EXIT; END

Triggers get replaced with:   AS Declare variable I integer; BEGIN I = 0; END

The database does not appear to be corrupt in anyway and validates fully with no issues.  I have backuped/restored, replaced the missing procedures and returned to the client only to find out today the triggers/procedures are missing again.

Can anyone enlighten me on why these might disappear, but not only disappear be replaced by empty procedures?  Where can I look for the cause?  My application does not alter the database DDL it only does CRUD type operations.

Thanks.