Subject | Firebird Windows authentication and backup |
---|---|
Author | Buerki, Daniel |
Post date | 2015-07-02T06:42:35Z |
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