Subject firebird 2.1
Author ognen_duzlevski
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?

Thanks,
Ognen