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.