On 08/08/13 19:27, jack.mason58 wrote: > gbak: ERROR: table/procedure has non-SQL security class defined
From http://sourceforge.net/mailarchive/forum.php?thread_name=5106F9F2.4040200%40ibphoenix.com&forum_name=firebird-devel At 01:07 a.m. 29/01/2013, Dmitry Yemanov wrote: >AFAIR, this is a known issue. ODS 11.2 databases cannot be restored on >older FB versions because it has other conventions to name security >classes (SQL$number instead of SQL$tablename, this was done to fix the >old security issue with longer than 27 chars metadata names) and these >new names, after being backed up successfully, are not accepted by older >FB versions due to their system triggers expecting the name in the old >format (SQL$tablename). > >I don't know about any solution other than migrating via a script. Might be helpful? Cheers, Norm. -- Norman Dunbar Dunbar IT Consultants Ltd Registered address: 27a Lidget Hill Pudsey West Yorkshire United Kingdom LS28 7LG Company Number: 05132767