English

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

Question

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

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.