Subject Re: Restore problems with grants
Author hfsnell
I have got the same problem
Old server version: 1.5.5
I backed up successfully
New server version:2.1.1
I restored and failed with the following messages:
gbak: restoring privilege for user SYSDBA
gbak: restoring privilege for user SYSDBA
gbak: restoring privilege for user SYSDBA
gbak: restoring privilege for user SYSDBA
gbak: restoring privilege for user SYSDBA
gbak: restoring privilege for user SYSDBA
gbak: restoring privilege for user SYSDBA
gbak: restoring privilege for user SYSDBA
gbak: restoring privilege for user SYSDBA
gbak: restoring privilege for user SYSDBA
gbak: restoring privilege for user SYSDBA
gbak: restoring privilege for user SYSDBA
gbak: restoring privilege for user SYSDBA
gbak: restoring privilege for user SYSDBA
gbak: restoring privilege for user SYSDBA
Database restore cancelled 19:41:07 due to IBPP exception:

*** IBPP::SQLException ***
Context: ServiceImpl::Wait
Message: isc_service_query failed

SQL Message : -901
Unsuccessful execution caused by system error that does not preclude
successful execution of subsequent statements

Engine Code : 335544342
Engine Message :
action cancelled by trigger (0) to preserve data integrity
could not find table/procedure for GRANT
Plz give me some hints
Thank in advance!
Phuoc
--- In firebird-support@yahoogroups.com, Bjoern Reimer
<bjoern.reimer@...> wrote:
>
> 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?
>
>
>
>