Look at the system tables. Don't know if it works on Fb 1.5, but I'd try something like

select *
from rdb$user_privileges u
where u.rdb$field_name is not null
and not exists(select * from rdb$relation_fields rf
where u.rdb$relation_name = rf.rdb$relation_name
and u.rdb$field_name = rf.rdb$field_name)

HTH,
Set

-----Original Message-----
From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of Ed Dressel
Sent: 12. februar 2013 22:03
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Inconsistency issue in FB 1.56

I backed up a (FB 1.56) database on my server and am trying to restore it on my local machine. I get the following error message in IB Expert:

<Error Message>
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.
</Error Message>

ouch... I don't know how to find where this is.... any suggestions are certainly welcomed.

Ed Dressel