Is This Content Helpful?
We're glad to know this article was helpful.
Why can I see so many tables when I connect to my RDBMS database using an OLE DB connection?
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.