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

Reply via email to