Subject Re: [firebird-support] firebird 2.1
Author Ognen Duzlevski

Thank you for taking the time to answer my question(s). Your example below did it. I am running superserver, by the way, and the line below worked. Sorry for top-posting, I can't figure out how to get out of the quoted text in Yahoo Mail...


>I am a new user - apologies if the question below has been chewed on. I come from a postgres background and decided to give FB a shot. Postgres will let you be a superuser who is allowed to create databases. Adding a user and granting this role is easy. As an ordinary user "joe", can I create databases in FB?
>I used GSEC to create a user "joe" with a password "testpass".
>Then I did "isql -u joe -p 'testpass'". I get the prompt where I type "create database /home/joe/test. fdb" to which I get a message:
>Statement failed, SQLCODE = -902
>Your user name and password are not defined. Ask your database administrator to set up a Firebird login.
>I also tried changing the directive DatabaseAccess to Restrict /db which is in turn owned by firebird:firebird and has permissions 777 - creating a database in '/db/test.fdb' fails equally.
>What gives?

You could try with proper CREATE DATABASE syntax:

CREATE DATABASE '/home/joe/test. fdb' USER 'joe' PASSWORD 'testpass';

[Non-text portions of this message have been removed]