Subject | firebird 2.1 |
---|---|
Author | ognen_duzlevski |
Post date | 2010-02-26T21:19:12Z |
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
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