Backup of an ODS 11.2 database was made on a v.2.5 server using the gbak.exe from v.2.0. The database structure doesn't use anything that v.2.0 doesn't support and has no permissions depending on the RDB$ADMIN role. The backup completed without any errors.
During the restore on the v.2.0.7 server, right at the start of restoring privileges: 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 PUBLIC 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 PUBLIC 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 PUBLIC gbak: restoring privilege for user SYSDBA gbak: ERROR:action cancelled by trigger (3) to preserve data integrity gbak: ERROR: table/procedure has non-SQL security class defined gbak:Exiting before completion due to errors Although gbak seems to be reporting the error at the 20th privilege, in fact only the first 6 privileges showed up in RDB$USER_PRIVILEGES in the ODS 11.0 database. If it's relevant, in a fresh restore of the original ODS 11.2 database under v.2.5, the 20th privilege is the second privilege on the first user table, SYSDBA granting INSERT WITH GRANT OPTION to itself. What does the error signify? Thanks, Helen ------------------------------------------------------------------------------ Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS, MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft MVPs and experts. ON SALE this month only -- learn more at: http://p.sf.net/sfu/learnnow-d2d Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
