On 01/26/2016 09:21 PM, Mark Rotteveel wrote: > On 26-1-2016 18:52, Leyne, Sean wrote: >>> The main reason it was not done are usage patterns. -F switch is needed in 2 >>> cases: >>> - After restoring backup of database using non-nbackup tools (i.e. >>> someone does: alter database begin backup; copies db-file using some non- >>> firebird tools; alter database end backup) and after is wants to restore >>> that >>> copy. But this anyway requires access to server console, i.e. command line >>> nbackup can be used. >>> - To activate database after loosing for some delta-file which should be >>> normally merged. This is emergency case (all transactions stored in delta >>> file >>> will be lost), and I do not want to make it possible to run it remotely. >> These are potentially destructive operations, why would we allow someone to >> execute these remotely?
That was my initial logic when not implementing it. >> Which user would be able to perform the operations? SYSDBA or database >> owner (could database owner even be verified in all cases)? SYSDBA only. Database owner can't be verified (if we do not take into an account raw reads from database file) cause file can't be opened as database when it needs fixup. > I can do a drop database remotely, I can do a restore database remotely > overwriting the existing database, I can drop tables remotely. Why would > this 'potentially destructive' operation be any different? It's pretty easy to mix 'end backup' and 'fixup'. Even in this list there was suggestion from someone to use 'alter database end backup' instead fixup. ;) ------------------------------------------------------------------------------ Site24x7 APM Insight: Get Deep Visibility into Application Performance APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month Monitor end-to-end web transactions and take corrective actions now Troubleshoot faster and improve end-user experience. Signup Now! http://pubads.g.doubleclick.net/gampad/clk?id=267308311&iu=/4140 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
