Subject Re: [firebird-support] Re: Active Directory Controller
Author Doug Chamberlin
At 03:09 PM 3/5/2006, yuppski wrote:
>OK, to be more specific I have users connecting to the database via
>a Delphi app. On that bases some have read/write access.
>
>So back to my orignal question, can Firebird be used on a "Active
>Directory Controller" as part of MS Server 2003?

Your question still is not clear. Are you asking if your Delphi app can
authenticate the current user and query the ADC for the rights that user
has with respect to a Firebird database? Or, are you asking if access to
the Firebird database can be granted automatically to a Windows user,
without separate login step to the Firebird database server, based on the
AD rights the user has?

Anticipating one of those is your question, or something similar, here is
some relevant info:
1) Firebird can be installed on a Windows 2003 Server, even one that is
acting as an ADC.
2) Firebird has its own user authentication/Login exchange with the client.
3) Your Delphi application can prompt the user for their Windows AD
credentials and authenticate them against the ADC.
4) Your Delphi app can then login to the Firebird server using a hidden
Firebird account, or using a Firebird account that parallels the AD account
using a password that is known to the app.
5) Someone may have adapted Firebird to access Active Directory for
authentication but I have not heard of it.

I hope this helps!