Subject | Re: [firebird-support] Restore problems with grants |
---|---|
Author | Bjoern Reimer |
Post date | 2005-03-23T15:45:03Z |
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
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