--- In firebird-support@yahoogroups.com, "Martijn Tonies"
<m.tonies@u...> wrote:

>
>
> > 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?
>
>
> Martijn Tonies
> Database Workbench - tool for InterBase, Firebird, MySQL, Oracle &

MS SQL

> Server
> Upscene Productions
> http://www.upscene.com
> Database development questions? Check the forum!
> http://www.databasedevelopmentforum.com
>

We have a compilation box and a running box. So lets say we compile
on BoxA and run on BoxB. After compilation we create a folder which
contains everything we need to run. This includes the database, say
called MyDB. We tar this up and install on BoxB or whatever other
box we decide to use. Well when a user tries to tar up our created
database MyDB, we get an error because we are neither the
user "firebird" or part of the "firebird" group which the database is
associated with. In Firebird-1.5-QuickStart.pdf, under
the "Important" box in the "Creating a database using isql" section,
it states, that using the classic server under linux first tries to
use the login of whoever is creating the database instead of the
default "firebird". We however are using ths superserver. Is there
a way to do this? Thanks so much for your time.