Creating and accessing the database requires the user to have rwx
permission on all the directories from / to the fdb file.
I tried too to access a database in /home/dir/ and since /home does
not have rwx permission it is not possible.
Create the database in /var/db or somewhere where every user has rwx permission.


On Sun, 26 Sep 2004 06:05:47 -0000, andrewstuartxx2000
<andrew.stuart@...> wrote:

> Hello I am a FGirebird newbie trying to create a database. ere's
> what happens. (Firebird 1.5 Linux redhat Fedora core 2, lots of
> diskspace)
>
> [root@xseappserver fb]# isql -h
> Unknown switch: h
> isql [<database>] [-e] [-t <terminator>] [-i <inputfile>] [-o
> <outputfile>]
> [-x|-a] [-d <target db>] [-u <user>] [-p <password>]
> [-page <pagelength>] [-n] [-m] [-q] [-s <sql_dialect>]
> [-r <rolename>] [-c <num cache buffers>] [-z] -nowarnings -
> noautocommit
> [root@xseappserver fb]# isql -u sysdba -p xRviTb7O
> Use CONNECT or CREATE DATABASE to specify a database
> SQL> CREATE DATABASE './xsecore.gdb' DEFAULT CHARACTER SET UNICODE;
> Statement failed, SQLCODE = -902
>
> I/O error for file "/home/sshlogin/fb/xsecore.gdb"
> -Error while trying to create file
> -Permission denied
> SQL>
>
> Any help would be much appreciated.
> Could you please email a copy of any responses to
> a n d r e w . s t u a r t @ x s e . c o m . a u
>
> Thanks
>
> Andrew Stuart
>
>
>
> Yahoo! Groups Links
>
>
>
>
>