Subject Problem restoring with gbak
Author martin_fay_arx
I've just been trying to test a backup/restore with gbak, and I'm
getting this error message in the restore (to a new file):

gbak: restoring privilege for user SRMAX
gbak: ERROR: action cancelled by trigger (1) to preserve data
gbak: ERROR: could not find column for GRANT
gbak: Exiting before completion due to errors

Can anyone explain possible causes of this?

I've had some niggles with privileges in this database before, with
an unexpected lack of rights on particular fields.

Examining the verbose output of gbak and opening the restored
database with IBExpert suggests all the database structure and data
is there, so I'm hoping security is the last stage of the restore.

(btw apologies if a moderator had to block an html version of this


Martin Fay
Software Manager
ARX Limited