Subject Re: [ib-support] User management / Meaning of the uid / gid
Author Helen Borrie
At 02:19 PM 28/01/2003 +0100, you wrote:
>Hello Markus,
>
> > 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?
>
>This refers to Unix user and group IDs. On Windows, these fields
>don't mean anything. On Unix, you can ignore them as well.
>
> > 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?
>
>In the system tables in each database. They all start with RDB$ and
>most tools don't show them by default. I don't know of a field that
>indicates "the" owner of the database, but every relation has an owner.

For relations, it is RDB$OWNER_NAME in RDB$RELATIONS. But RDB$DATABASE
doesn't have an owner_name field so it's a bit harder to track down how the
server knows who is the owner of the database.

Ann will know....

heLen