Hi,
While restoring a database with FB 3.0 beta 1 (backed-up with FB3 alpha 2), I
get this error:
action cancelled by trigger (3) to preserve data integrity
object has non-SQL security class defined
Exiting before completion due to errors
SQL state: 27000
SQL code: -901
FB version: WI-T3.0.0.31369 Firebird 3.0 Beta 1
The last items from the gbak log:
gbak: restoring privilege for user RJ (3)
gbak: restoring privilege for user COS
gbak: restoring privilege for user RJ
gbak: restoring privilege for user COS (2)
gbak: restoring privilege for user SYSDBA
operation failed
I also restored it under FB alpha 2 (WI-T3.0.0.30809 Firebird 3.0 Alpha 2), and
this worked fine.
Before I post a bug report, has someone a suggestion?
A dump of the content of rdb$user_privileges (before restore) can be found
here: http://www.rjmittendorff.nl/user_privileges.txt
Thanks,
Robert
------------------------------------------------------------------------------
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel