Subject Error during restore
Author r.kumta
Dear Sir,

I am using Firebird Version 2.0.4 on Windows XP. I have a 960 MB
database with about 250 tables.

When I run gbak on the database as SYSDBA, the .fbk file is getting
created ok. However, when I run a restore with this .fbk with gbak,
all the metadata is restored correctly. Almost all the data is
restored correctly. But, almost at the end of the restore, when gbak
is trying to restore the priveleges for the user SYSDBA, it encounters
the following error:

gbak: action cancelled by trigger (3) to preserve data integrity
gbak: table/procedure has non-SQL security class defined

The restore fails. I am not able to understand this error. What is a
non-SQL security class?

Any help will be greatly appreciated. Thanks.

Rahul