653 views

Determining whether user is missing query role to view ODBC data 

 

Symptoms
  • Cannot view ODBC data 
  • Data can be viewed in UI but not in ODBC
 
Cause
The user does not have the soap_query role to view data in ODBC.
Resolution
ODBC uses SOAP web services. If you have glide.soap.strict_security set to true, you need to add the soap_query role to the user. You can also use the odbc role starting with Helsinki.

Article Information

Last Updated:2016-05-08 05:05:19
Published:2014-11-03