On 02/08/2016 06:50 PM, Stefan Heymann wrote: >>> Is there a way to restore my database without the need to use another >>> security database? Thereby keeping XYZ as the owner? I don't see there >>> is anything in GBAK that could create the new owner user during the >>> restore. >> Restore it in embedded mode using user name XYZ (password is not >> checked) and then >> create user XYZ by gsec using user name SYSDBA. > GSEC is deprecated, so this won't work in the future.
It will not work even in FB3, gsec does NOT understand multiple security DBs. So please use isql: isql -user xyz your-database.fdb SQL> create user XYZ password 'zyx'; > Can I simply > switch between server and embedded mode? You need not switch - you may access some databases as embedded, others - using server (that's about SS, in case of classic you may access same database as embedded and server simultaneously). In a case you have problems trying to access some database embedded you may try to stop superserver - may be somebody is/was using server access to it. > Or do I need separate > Firebird (one embedded, one server) installations for that? No you need not. ------------------------------------------------------------------------------ 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=272487151&iu=/4140 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
