I have firebird server running as a service on a central computer that is also a workstation. The database is accessed from the local machine that it is stored on as well as from another workstation. I have noticed that even though I have password access turned on for sharing the application using the database doesn't seem to get held up and never askes for the credentials. Is this normal? I hope it is as it is very convenient in this situation but not what I was expecting.
Firebird is client/server based (either via TCP/IP or Named Pipes). On the server side it will simply be accessing the local file, so the only permissions that apply will be those of the Firebird service.