Subject Firebird 2.5 windows authentication and roles grants question?
Author marto94114
Hi guys,

I `ve read all support docs included in firebird 2.5 installation together with several internet articals but I could not find a solution of the following problem I have:
I am using firebird 2.5.1 x64 version on Windows Server 2008 R2 Enterprise. This machine is part of a domain structure. My account is part of a D-RND group in that domain. The Firebird is configured in mixed authentication (I've tried "trusted" also).
I have a database called XXX.FDB. I define several tables and views as SYSDBA. I also define a role called D-RND and grant all rights for all tables and views to that role.
Everything is OK till here.
When I try to connect using trusted authentication and role D-RND, after open the database and try to select/update/insert whatever table or view I receive the error " This user does not provolige to perform this operation on this object. No permission for <operation> access to <table/view> ".
Please help what should I do? Why it happens like that?

Regards

P.S. This scene works under Firebird 2.1.