this is a new installation no existing databases no legacy code to support.
After installing the 64bit server on windows 7 machine file name Firebird-3.0.5.33220_0_x64.exe then do the following c:> "c:\Program Files\Firebird\3_0\isql.exe" Use CONNECT or CREATE DATABASE to specify a database SQL> connect localhost:employee user sysdba password masterkey; Database: localhost:employee, User: SYSDBA SQL> create user macky password '1234' grant admin role; SQL>quit; now I'm not interested in using sysdba for anything else just create my own super user and use that for everything. so next step create a new database c:> "c:\Program Files\Firebird\3_0\isql.exe" Use CONNECT or CREATE DATABASE to specify a database SQL> create database 'localhost:D:\data\firebird\macky.fdb' default character set utf8 user macky password 1234; Statement failed, SQLSTATE = 28000 Your user name and password are not defined. Ask your database administrator to set up a Firebird login. SQL>quit; What the F? ok lets test that c:> "c:\Program Files\Firebird\3_0\isql.exe" Use CONNECT or CREATE DATABASE to specify a database SQL> connect localhost:employee user macky password 1234; Database: localhost:employee, User: MACKY SQL> select Sec$User_name from sec$users; SEC$USER_NAME =============================== MACKY SQL> quit; erm there is something I'm missing here lets try to grant the database create rights to the macky C:> "c:\Program Files\Firebird\3_0\isql.exe" Use CONNECT or CREATE DATABASE to specify a database SQL> connect localhost:employee user sysdba password masterkey; Database: localhost:employee, User: SYSDBA SQL> grant create database to macky; Statement failed, SQLSTATE = 0A000 unsuccessful metadata update -GRANT failed -feature is not supported -Only grants to USER or ROLE are supported for CREATE DATABASE SQL> grant create database to user macky; SQL>quit; OK now that should do the trick, lets test it. C:> "c:\Program Files\Firebird\3_0\isql.exe" Use CONNECT or CREATE DATABASE to specify a database SQL> create database 'localhost:D:\data\firebird\macky.fdb' default character set utf8 user macky password 1234; Statement failed, SQLSTATE = 28000 Your user name and password are not defined. Ask your database administrator to set up a Firebird login. SQL> I give up. any idea what I'm doing wrong here? for now I'm going to use one of the free gui admin tools in embedded mode but if the user management and stored proc thingy doesn't get better any time soon I'll drop firebird altogether. thank you for your time. Your efforts are greatly appreciated regardless of outcome.
