Hi, (I repost this message in this category becasue no one response on the
other category)

I am running the openrowset query against oracle instance by using 'MSDAORA'
driver. Using SQL account or NT account with sysadmin right, the query
execute successfully. But, if I use an account with only db_owner or
db_datareader or db_datawriter or db_ddladmin to execute the openrowset
query, the following message would show

Ad hoc access to OLE DB provider 'MSDAORA' has been denied. You must access
this provider through a linked server.

Which right in database level need to grant to a user to execute OPENROWSET
query? Or is sysadmin instance right require to execute OPENROWSET query?
Can't find the right info in BOL.
--
Best Regards,

Lynn