Subject | Re: [firebird-support] Re: Architecture of Firebird |
---|---|
Author | Helen Borrie |
Post date | 2006-04-10T10:13:52Z |
At 07:44 PM 10/04/2006, you wrote:
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
>Thanks for the clear answers!Yes and no. Any authenticated user can *connect* to any
>
>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.
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