Subject Re: [firebird-support] Embedded users and roles
Author Helen Borrie
At 04:53 PM 11/04/2004 +0000, you wrote:
>The embedded firebird does not seem to support users (in that you
>cannot add users, or can you?)

No, embedded bypasses server security. You can use any user name to log in
to the embedded server, even one that doesn't exist.


>But it seems to implements roles.

Roles are database-based.


>If I cannot create a user and grant the user the role created what it
>the point of implementing user_roles in embedded mode?

Because roles are related to permissions and permissions are the only way
you can impose any sort of security.


>If I can add a user can I add it via a SQL call?

No. A user belongs to a server, not to a database. No server means no
user authentication.

/heLen