Subject Re: [firebird-support] Newbie trying to create databas
Author Federico Tello Gentile
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
> 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