I have installed the Oracle OLEDB provider and am now using that. Connection test successful, but when I run a query with openquery, I get this:

Msg 7399, Level 16, State 1, Line 11

The OLE DB provider "OraOLEDB.Oracle" for linked server "Ora_Stud" reported an error. Access denied.

Msg 7350, Level 16, State 2, Line 11

Cannot get the column information from OLE DB provider "OraOLEDB.Oracle" for linked server "Ora_Stud".

When I run the query with four-part name and do not use openquery, I get this:

The OLE DB provider "OraOLEDB.Oracle" for linked server "Ora_Stud" does not contain the table ""StudOwner"."Student_Directory_Info"". The table either does not exist or the current user does not have permissions on that table.

The user has 1) connect privileges to the Oracle instance and 2) select privileges on this view. I can log on and query the view fine with the user's credentials.

I am wondering if the user needs some additional permissions on the Oracle side to be able to obtain metadata needed by SQL Server 2008 R2.