At 06:37 PM 17/12/2004 -0500, you wrote:

>Thanks helen.
>I got it working, just was about to email the group. I did that and
>restarted the server. I solved one issue and had an other.
>The problem really is caused when the file security.fdb is copied over
>from the CD to disk, it puts a read only property.
>The db connection or gsec would not work and returns "no read-write
>permissions on the database "...All works as soon as I manually turn the
>readonly off.

That has nothing to do with Firebird. Every file that you write to a CD
gets its read-only attribute set on.

>While I can do that programatically, iam just curious to know why I get
>no read-write permissions. I do have read-only.

The security.fdb file contains a database. While any ODS-10 or higher
database can be made a "read-only database" (using gfix, not file
permissions!!), security.fdb is NOT a read-only database. No database can
be accessed in a *file* that is read-only at filesystem level.

>Does firebird server write something to the security database.

Of course. All database accesses write something, even if it is only a
transaction that is never explicitly written to disk.

Firebird is not a file-served database management system. It is a database
management system that (usually) resides in a file. It's theoretically
possible to have a database that resides on a raw partition and is treated
by the OS as a device. The server still sees it as a file.

./heLen