Hi,

we maintain an application that uses Firebird as its database backend.
During the installation of the application we install the Firebird
server and create a new user. The database files are pre-prepared before
that and already contain data. The application has to access the
database (r/w) as the user (say "appuser") we created during the
installation process. We have found a SQL script that changes the owner
of relations to a certain user. The questions that arose are:

1. When I create a user, the default uid and gid is 0, the same as
SYSDBA. This sounds rather strange to me. What meaning does the uid/gid
have?

2. Firebird is not like other databases where you have a server, and the
server knows which databases it has. With Firebird you just need a
server and bring in the database file yourself, using the server to
access it. Where is the information, to what user a certain database /
relation belongs, stored? I.e., what gets changed where when I execute
that script (attached)?

Thanks

--
Markus Bertheau <bertheau@...>
Cenes Data GmbH


[Non-text portions of this message have been removed]