Permissions for connecting via SNOW ODBC

[cnackers]

We are trying to connect using the ServiceNOW ODBC driver to be able to query data to generate some reports and update some information in SharePoint.  

I haven't been able to identify what permissions are required to allow this without being a full Admin.  The Rest API roles don't allow connection via ODBC.

Can anyone point me in the right direciton?

Thanks!

[Chuck Tomasi]

Access to the tables is enforced as the person who used their credentials to connect. For example, if I connect as chuck.tomasi and do not have access to the HR tables, the ODBC connection does not have access to those tables.

ODBC Driver - ServiceNow Wiki

[Chuck Tomasi]

This may also be helpful reference:

Docs: Access control rules

Docs: Contextual security  

Security Best Practices - ServiceNow Wiki

[cnackers]

So there isn't a specific role we can use? Instead it's based on the ACL's for that person?  

[Chuck Tomasi]

That's what the docs say, although I discovered this on my Istanbul instance as well. If your personal credentials don't get you what you need, try adding that to the user making the attempt and let me know. I'll be curious to find out as I don't have a machine to test this on at the moment.