realoldgeek2008 wrote:

> I'm a Visual Foxpro developer using Firebird as my applications' data
> store. Trying out Firebird 2.1's out new trusted authentication
> capability, I have removed the UID= and password= clauses from my ODBC
> connection strings. I find that while connections to my data bases
> remain successful, any attempt to access their tables yields an ODBC
> driver "No permission for read/select access to table... " error
> unless the user is an administrator. I have verified that the
> non-administrative users do have rights grants to the applicable
> tables, including system tables.

With trusted authentication, table permissions should be granted to the
Windows users, e.g. "DOMAIN\\USER". While you're connected in the
"trusted way", check the value of CURRENT_USER and make sure that you
have all necessary permissions granted to that user.


Dmitry