Hi, on Windows with Firebird 3.0 server, I have successfully used isql to create databases, add users, create tables, manipulate data, not the easiest of interfaces, but in the end it works. This so I can connect to these databases through LibreOffice 6.3. I have been trying to use FlameRobin as a GUI to manage the Firebird databases, the interface is better, except for one problem I haven’t been able to solve: I cannot persuade FlameRobin to create a database unless the user is SYSDBA.
Here is my example: in isql I have created a user called “webusrjhn” and granted it an admin role. In isql, it successfully creates a database with: SQL> CREATE DATABASE ‘C:\d\libre\sixthddb.fdb’ user ‘webusrjhn’ password ‘whatever’ default character set UTF8; When I try to do the same in FlameRobin (even if running as administrator), I get the following error message:
***IBPP::SQLException*** Context: Database::Create Message: isc_dsql_execute_immediate failed SQL Message: -551 can't format message 13:449 -- message file C:\Windows\system32\firebird.msg not found Engine Code : 335544352 Engine Message: no permission for CREATE access to DATABASE C:\D\LIBRE\SEVENTHDB.FDB
The same sequence using SYDBA as user works fine.
I realise this is a minor irritant, but how can I solve this? Thanks.