Hi,

I notice that file can't be created from a windows client app, what
I'm doing is:

login in as 'root'
create a file in isql,
SQL> create database '/home/fdb/test.fdb' page_size 8192;

but test.fdb is owned by root, have to:chown to firebird.firebird

then connect from a windows client, run a script to create tables.

if i login as 'firebird', and run isql, i got an error:

unable to open

why user firebird can not run isql?

Thanks,

Frank



--- In firebird-support@yahoogroups.com, Milan Babuskov <milanb@...>
wrote:

>
> Helen Borrie wrote:
> > And don't forget that the 'firebird' user must have at least group
> > ownership permissions to the filesystem location and at least
> > group-level rwx permissions to the directory where the database file
> > is to be created/accessed.
>
> To be more exact: rwx for creation, r-x for access. Most of my

databases

> are in this directory:
>
> drwxr-x--- 2 root firebird 888 2006-10-11 17:40 /baze/
>
> This ensures that only root can create databases, while regular

Firebird

> users cannot.
>
> --
> Milan Babuskov
> http://swoes.blogspot.com/
> http://www.flamerobin.org
>