Hi,

> I'm using the standalone (embedded) version of Firebird (in order to
> make the installation and maintenance as simple as possible).
>
> It seems that this version doesn't support password protection. This
> is a major problem since all end users would be able to read and even
> modify the content of the database. It would open the door to endless
> support issues.
>
> Can this embedded version be locked in any way so that only my code
> could access the data ? I've been using Access which password
> protects the local file but allows to provide the password from the
> code accessing the DB. Is there the same feature in FB ?

Having no password security is one of the gotchas for "embedded"
as mentioned in the documentation.

You know, Firebird Embedded isn't really an embedded server,
it's more like "direct access" to your datafiles.

It doesn't use a security database and until plugable security comes
along, don't expect "embedded" to be secure.

I haven't tried, but do "roles" still work?

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com