I have a problem in adding a linked server from sql 2005x64 to oracle.
I have created the linked server
EXEC sp_addlinkedserver
@server = 'job',
@srvproduct = 'Oracle',
@provider = 'OraOLEDB.Oracle',
@datasrc = 'tns'
and added a login
sp_addlinkedsrvlogin @rmtsrvname = 'job'
, @useself = 'false'
, @locallogin = 'opTrasp'
, @rmtuser = 'remUs'
, @rmtpassword = 'pwd'
but I have the error
The EXECUTE permission was denied on the object 'xp_prop_oledb_provider', database 'mssqlsystemresource', schema 'sys'. (Microsoft SQL Server, Error: 229)
in the test server, running sql 2000 instead of sql 2005) it worked without assigning any further permission to the local login.
Is it necessary? and is it 'dangerous', considering that it is a cluster with many critical databases of different suppliers?
Thanks in advance for your kind replies.
sb