Determining whether missing ACLs are causing access issues with ODBC queries
Symptoms
- Query returns error message
- Queried returns table column names but not values
- Query does not allow read access
Cause
There are no ACLs defined for a table to allow access to the user. If ACLs are not defined, the default is to deny access to the user without the admin role.
Resolution
You may receive this error message when running an ODBC query:
[DataDirect][ODBC OpenAccess SDK driver][OpenAccess SDK SQL Engine]Could not find any column information for table:<table_name>.[10131]
To allow read access, add an ACL for a particular role, and add that role to the user record. The odbc role is provided by default starting with Helsinki. Make sure to verify and add all necessary ACLs.