Subject Re: Odp: [firebird-support] Firebird 2.52 gbak fails to do a restore - error trigger (3)
Author Jack Mason
Thank you very much.  I will get a chance to try the -o switch this weekend when everyone goes home.


On 6/12/2015 2:25 PM, Ann Harrison aharrison@... [firebird-support] wrote:

On 6/12/2015 2:11 PM, Jack Mason jackmason@... [firebird-support] wrote:
Thank you very much.   I will try the  -o switch and the gfix suggestion as well.

Don't bother with gfix.  It does a physical database check - pointers point to what
they should, pages are the right type, etc.  Your problem is with the logic of the database,
specifically with one of the grants.  

From a very historical point of view, InterBase was created with a security model that
everything was allowed unless prohibited.  SQL's model is that nothing is allowed
unless permitted.  Some odd things were done to convert from the InterBase model
to the SQL model and not all of them were done well.  You seem to have tripped over
one of those issues, probably something that worked OK with earlier versions of
Firebird, but which contemporary Firebird rejects. 

Good luck,


"Our Constitution was made only for a moral and religious people. It is wholly inadequate to the government of any other." -- John Adams, Oct. 11, 1798 "Where there is no vision, the people perish.." Prov 29:18