ognen_duzlevski wrote:

> 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.

In addition to Helen's comments - see if your distribution has 'flamerobin'
available. This is an ideal GUI interface which will show you everything 'under
the hood' in the databases you are creating ;)

--
Lester Caine - G8HFL
-----------------------------
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk//
Firebird - http://www.firebirdsql.org/index.php