SQL Server - linked Oracle server: EXECUTE permission denied on 'xp_prop_oledb_provider'
On the SQL Server where the linked server is defined, execute:

Use MASTER
GRANT EXECUTE ON SYS.XP_PROP_OLEDB_PROVIDER TO public


Does anyone have any comments on the security implications of this?