Permission for ODATA

jwilder

I can only get ODATA working in Excel for users by making them a SuperUser. There must be some system table(s) that is required to give them access to ODATA such as table 2000000076 Web Services and maybe others. Does anybody know the required tables needed to use ODATA (besides the actual tables you are pulling the data for).

Kishorm

Have you given permission for the query / page that you are publishing as the web Service?

jwilder

Yes in our foundation permission set we have included access to all queries.