I am the SQL Server admin.
I am using a SQL account with SELECT privileges for one table.
When I use an OLEDB connection, the 'select data to load' process, lists the one 'granted database' the account has access to as well as msdb, master and tempdb.
The 'granted database' lists all the other owners (schema) in the database. The dbo, sys and INFORMATION_SCHEMA owner, shows the objects in these schemas.
Under the databases msdb, master and tempdb, the owners' listed include dbo, sys and INFORMATION_SCHEMA.
When I use the same account with ODBC connection, I see every database on the server. The other 'user' databases does not list any owners, but the same visibility to msdb, master and tempdb databases and schemas dbo, sys and INFORMATION_SCHEMA objects.
Ideally, I want to limit the view of database objects to our user community to data that we have provided read capability to.
Below is an example of the objects under msdb database and INFORMATION_SCHEMA displays.