Subject Re: [firebird-support]Restore - cannot find column for grant?
Author Thomas Steinmaurer

> Cant fully restore a freshly backup up FB1.5 D1 database - error
> IBE: Unsuccessful execution caused by system error that does not preclude
> successful execution of subsequent statements.
> action cancelled by trigger (1) to preserve data integrity.
> could not find column for GRANT.

This is a bug in FB 1.5.3 (haven't tried with FB 1.5.4 and FB 2.0.x),
which is fixed in FB 2.1 Alpha.

It has to do with granting field based update operations to users and
not removing the according record in the RDB$USER_PRIVILEGES table when
dropping the field. So there is a record in this system table for a
field which doesn't exist anymore.

> How can I fix this?

Execute the proper REVOKE statement before creating a backup.


Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions