> how can I get Firebird ODBC driver to connect to an embedded server by using the security2.fdb?
>
> Is there any reason, why the security2.fdb is being ignored in that case at least by default?
>
> That way the ODBC connection can only be created with SYSDBA as user and there is no way to make the connection read only. I mean yes, you can check the checkbox "read" when creating the connection, but the end user can uncheck it at any time and gat a write access to the DB...
>
> For the ODBC connection to a normal server he could do the same of course, but since in that case the connection cen be created with a user, who has read rights only, it doesn't matter if the checkbox gets unchecked.
>
> Why can't it work the same with embedded server? That doesn't make sense to me... Can I accomplish it in any way?

Embedded works that way: The provided user/password combination isn't
checked against the security database, but SQL privileges are checked
for the provided user when it comes to accessing tables, views etc ...


--
With regards,
Thomas Steinmaurer

* Upscene Productions - Database Tools for Developers
http://www.upscene.com/

* My Blog
http://blog.upscene.com/thomas/index.php

* Firebird Foundation Committee Member
http://www.firebirdsql.org/en/firebird-foundation/