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. I'm using Firebird 2.1.1 with
Firebird/Interbase ODBC driver 2.00.00.144. I've tried both the
default "Mixed" and "Tusted" as the Authentication setting in
firebird.conf. Perhaps I misunderstand some aspect of trusted
authentication. Any advice appreciated.