Subject | Re: [ib-support] User management / Meaning of the uid / gid |
---|---|
Author | Paul Vinkenoog |
Post date | 2003-01-28T13:19:55Z |
Hello Markus,
don't mean anything. On Unix, you can ignore them as well.
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.
To me, the owner of the system tables is the creator/owner of the
database. I suppose you could change the ownership of some (but not
all) system tables to create some confusion... but in general you
shouldn't mess with those tables.
script in de message body if you want us to see it. Or place it
somewhere and post the URL.
Greetings,
Paul Vinkenoog
> 1. When I create a user, the default uid and gid is 0, the same asThis refers to Unix user and group IDs. On Windows, these fields
> SYSDBA. This sounds rather strange to me. What meaning does the
> uid/gid have?
don't mean anything. On Unix, you can ignore them as well.
> 2. Firebird is not like other databases where you have a server, andIn the system tables in each database. They all start with RDB$ 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?
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.
To me, the owner of the system tables is the creator/owner of the
database. I suppose you could change the ownership of some (but not
all) system tables to create some confusion... but in general you
shouldn't mess with those tables.
> I.e., what gets changed where when I execute that script (attached)?Attachments are automatically removed, so you'd have to include the
script in de message body if you want us to see it. Or place it
somewhere and post the URL.
Greetings,
Paul Vinkenoog