Subject Re: [firebird-support] gbak trigger(3) error
Author Norman Dunbar
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