[sconan]

Does anyone have information on what permissions we need to setup for an account to have access to ODBC?

We have added “Advanced Analytics” to a custom role and the user is able to do the following:

1. Login using an ODBC client.

2. See all the tables and fields in those tables.

3. Run queries and get back column header information.

The issue we are having is that no data comes back in the result set. The same query when run from an Administrator role comes back with the correct data.
This is a cached copy. Click here to see the original post.

[ivan.parra]

RE: ODBC Access from a Non-Adminstrator Role – No Data is Returned

Permission restriction is dependent on the type of data being requested. What tables are you accessing?

[sconan]

RE: ODBC Access from a Non-Adminstrator Role – No Data is Returned

Hey Ivan,

We’re using the following tables:

Contacts

Customers

Employees

Message

Sales_Reps

Support_Incidents

Support_Reps

Territory

[Author]

Posts