Subject Re: gbak trigger(3) error
Author jack.mason58
Thanks for your response, but this doesn't appear to be relevant as we do not know what ODS is, have never used it, and created the database brand new under Firebird 2.5.

--- In firebird-support@yahoogroups.com, Norman Dunbar <Norman@...> wrote:
>
> 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
>