Firebird 2.5中的Windows身份验证 [英] Windows Authentication in Firebird 2.5

问题描述

我可以使用Windows用户而不是SYSDBA和MASTERKEY凭据登录到firebird数据库吗?如果是，请告诉我连接到firebird数据库的方式.

Can I login to firebird database using a Windows user instead of using SYSDBA and MASTERKEY credential? If Yes, please let me know the way to connect to the firebird database.

我正在使用Delphi XE3和Firebird 2.5.我需要在更新受信任"的配置文件(如此处指定的默认本地")后，通过登录用户对用户进行身份验证:

I am using Delphi XE3 and Firebird 2.5. I need to authenticate user by logged in user after updating config file for "trusted" in place of default "native" as specified here: https://firebirdsql.org/file/documentation/release_notes/html/en/2_5/rnfb25-fbconf-authent.html

这是我的代码:

SQLConnection1.LoginPrompt := False;
//SQLConnection1.Params.add('user_name='); 
//SQLConnection1.Params.add('password='); 
SQLConnection1.Params.add('os authentication=True') ; 
SQLConnection1.Connected:= True

它仍然要求提供凭据.

推荐答案

(V.2.1)从Firebird 2.1开始，Windows受信任的用户"安全性可以 用于在Windows主机上对Firebird用户进行身份验证.这 受信任用户的安全上下文会传递到Firebird服务器，并且 如果成功，则用于确定Firebird安全性用户 名称.

(V.2.1) From Firebird 2.1 onward, Windows "Trusted User" security can be applied for authenticating Firebird users on a Windows host. The Trusted User's security context is passed to the Firebird server and, if it succeeds, it is used to determine the Firebird security user name.

只需从DPB/SPB中省略用户和密码参数，即可 自动导致应用Windows受信任的用户身份验证， 在几乎所有情况下.请参阅下面的环境"部分以了解 例外

Simply omitting the user and password parameters from the DPB/SPB will automatically cause Windows Trusted User authentication to be applied, in almost all cases. See the Environment section, below, for exceptions

来自官方文档

也请看一下这个问题- https://dba.stackexchange.com/questions/154735/how-to-enable-windows-authentication-in-firebird-2-5

Also, take a look at this question - https://dba.stackexchange.com/questions/154735/how-to-enable-windows-authentication-in-firebird-2-5

这篇关于Firebird 2.5中的Windows身份验证的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！