FAQ: Why Can I See so Many Tables When I Connect to My RDBMS Database Using an OLE DB Con

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

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

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

Answer

Discover more on this topic