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: [email protected]
[mailto:[email protected]] On Behalf Of Ed Dressel
Sent: 12. februar 2013 22:03
To: [email protected]
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
