On 01/28/13 13:12, Helen Borrie wrote: > 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? >
Probably a bug. Can it be reproduced with metadata-only backup? If yes, can we take a look at that .gbak? ------------------------------------------------------------------------------ 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
