> -----Original Message-----
> From: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com] On Behalf Of Martijn Tonies
> Sent: Tuesday, January 24, 2006 4:23 PM
> To: firebird-support@yahoogroups.com
> Subject: Re: [firebird-support] Linux DB ownership at creation
>
>
> > I am using Firebird version 1.5.2 on a Redhawk 2.2.2 blade
> box. The
> > super server is running. When I create a new database,
> lets call it
> > MY_DB, the owner is "firebird" who belongs to a group
> "firebird". I
> > would like to have the owner be the linux login id of the person
> > creating the database and the group be that user's linux
> group. I do
> > not want to add a user to MY_DB, I just want to have its owner and
> > owner's group be whoever actually created it. Thank you
> for your time.
>
> Why?

Exactly what I was wondering, there's plenty of good reasons for running
firebird under a specific user (in this case firebird) and the firebird
user wouldn't be able to access the database created with some other
user, unless permissions were set so lax as to allow anyone read-write
access.. Which I don't think is the intention here.

If you just want databases to be created with some other user/group you
should be able to change that in firebird startup script. Another
option might be to run multiple servers on different ports for different
users.. But that sure sounds like an administration nightmare..