Subject Re: [firebird-support] Re: Architecture of Firebird
Author Helen Borrie
At 07:44 PM 10/04/2006, you wrote:
>Thanks for the clear answers!
>
>One question concerning the users.
>You create the user on the servel-level (and not in the db). All
>users that are known on the server are available in the database to
>give then the correct rights.
>
>So every database has the same user-list.

Yes and no. Any authenticated user can *connect* to any
database. However, the user must be given the appropriate *database*
privileges to be permitted to access anything in that
database. These privileges reside inside the user database. Only
the database Owner or the SYSDBA user may grant privileges
intially; although the privilege to grant privileges can be passed
on to other users.

Firebird uses the SQL-standard syntax for granting and revoking
privileges and roles (roles are packages of privileges that can be
granted as-a-whole to a user).

./hb