Subject Firebird Windows authentication and backup
Author Buerki, Daniel
Hello,

I have two questions regarding windows authentication.

1.
I have set Authentication = trusted and granted the rdb$admin role to my windows user.
With this, I was able to do a backup using  nbackup without setting username/pw.

I then tried to do a backup on the same database using the .NET Provider with FbNBackup (and FbBackup) without username/pw using trusted authentication.
I hadn't been able to get this running.
I was getting "No user name was specified".

2.
When I set Authentication = trusted, every Windows User can query the database, even non-Admin users.
Is there a way to restrict this that only one selected Windows User can query the DB?

Environment:
OS: Windows 7
DB: Firebird Super Server 2.5.3.26780 (64bit)
.NET Provider: FirebirdSql.Data.FirebirdClient-4.6.2.0-NET45

Thanks and best Regards

Daniel