Topic: Adjustment Linked Server.
Kind time of days!
Is MS a SQL Server 2008 R2, during age-old times adjustment of a link with basis has been made, probably swore on access to meta data and unwinding adjustment allow in process is made. Problems especially was not, but one of these days it was necessary to alter the data on procedure, which a certain error and process of the SQL Server . Article is found in general, which describes adjustment of these rights to remove a daw in adjustment of the provider.
However now a certain difficulty at reversal to Linked Server users, namely - works only with rights ServerAdmin. Otherwise an error "Cannot create an instance of an OLE DB provider" OraOLEDB.Oracle "for linked server". How correctly to grant the rights to OLE DB Provider, but not to give SA?