Frequently asked question

Why can I see so many tables when I connect to my RDBMS database using an OLE DB connection?

Last Published: April 25, 2020

Answer

An OLE DB provider connection will return a list of qualified table names in the format <schema name>.<object name> which includes:

- Any tables you own.

- Any tables you have been granted object privileges on (select, insert, delete, update, etc.).

- Any tables where any of the object privileges have been granted to a role assigned to you, for example, the Public role.

Article ID:000002589

Software:
  • ArcMap 8 x

Receive notifications and find solutions for new or common issues

Get summarized answers and video solutions from our new AI chatbot.

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options