Subject Re: [firebird-support] Restore problems with grants
Author Bjoern Reimer
Hi,

had a similar or the same problem with another database:

gbak: restoring privilege for user SYSDBA

gbak: restoring privilege for user SYSDBA

gbak: restoring privilege for user SYSDBA

gbak: ERROR: action cancelled by trigger (0) to preserve data integrity

gbak: ERROR: could not find table/procedure for GRANT

gbak: Exiting before completion due to errors


What's the cause?

I think I've done a wrong grant on one of the system tables. But
which?



BR> Hi,


BR> restoring a somewhat bigger database I'm getting the following error:

BR> [...]

BR> gbak: restoring privilege for user SYSDBA

BR> gbak: restoring privilege for user SYSDBA

BR> gbak: restoring privilege for user SYSDBA

BR> gbak: restoring privilege for user SYSDBA

BR> gbak: restoring privilege for user SYSDBA

BR> gbak: ERROR: action cancelled by trigger (0) to preserve data integrity

BR> gbak: ERROR: could not find table/procedure for GRANT

BR> gbak: Exiting before completion due to errors


BR> What's that? Any hints?





BR> Björn





Mit freundlichen Grüßen

Björn Reimer

--
Björn Reimer -- RRZE
Tel: +49-9131 - 85-27809
Fax: +49-9131 - 302941
Martensstr. 1 / 2.021
D - 9 1 0 5 8 Erlangen
www.rrze.uni-erlangen.de