I verified the user account. It does work when I request data through MS Access to the Oracle table.

I used Microsoft ODBC for Oracle. I believe that I referenced a DSN on the SQL Server. As for running the query on the SYS.ALL_USERS, I don't have...

The linked server is named 'Warehouse'. Here is the select statement that should return the data in our 'Products' table. I don't get a thing but headers:

select *...