|Subject||Re: [firebird-support] gbak trigger(3) error|
On Fri, 09 Aug 2013 07:41:27 +0100, Norman Dunbar <Norman@...>
> On 08/08/13 19:27, jack.mason58 wrote:http://sourceforge.net/mailarchive/forum.php?thread_name=5106F9F2.4040200%40ibphoenix.com&forum_name=firebird-devel
>> gbak: ERROR: table/procedure has non-SQL security class defined
> 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
> >FB versions due to their system triggers expecting the name in the oldThis might indicate that the gbak version used is from an older version of
> >format (SQL$tablename).
> >I don't know about any solution other than migrating via a script.
> Might be helpful?