At 10:03 p.m. 27/02/2014, Alex Peshkoff wrote: >On 02/27/14 12:32, Helen Borrie wrote: >> With Fb 3 alpha 2 on Windows, is there any way to get SYSDBA into the >> security database, other than installing everything on Linux first, >> initializing it there and file-copying the security db to the Windows box? >> > >Helen, I did not check on windows but I suppose that installer should >perform all required actions. If not: >1. Stop running service. >2. The following scenario is from linux but I see no reasons for it not >to work on windows: > ># ./isql -user sysdba employee >Database: employee, User: sysdba >SQL> select * from sec$users; -- not required - just to make sure >init was not done yet >Statement failed, SQLSTATE = 28000 >find/display record error >-Install incomplete, please read chapter "Initializing security >database" in Quick Start Guide >SQL> create user sysdba password 'masterkey'; >SQL> > >If you get some error with it - please send them here.
Thanks, Alex, all was good *when I used the embedded approach* as in your example. It works just like on Linux. What I was attempting wouldn't work because I have Classic installed and was attempting to connect to hostname:employee. Observation: I had to commit explicitly following the CREATE USER statement. I guess it's really not "pure DDL" to be affected by autoddl=on...? Helen ------------------------------------------------------------------------------ Flow-based real-time traffic analytics software. Cisco certified tool. Monitor traffic, SLAs, QoS, Medianet, WAAS etc. with NetFlow Analyzer Customize your own dashboards, set traffic alerts and generate reports. Network behavioral analysis & security monitoring. All-in-one tool. http://pubads.g.doubleclick.net/gampad/clk?id=126839071&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
