Hi guys ,
I have a linked server from witch i can select data .. like select * from 'srv'.'db'.sys.syslogins .
But i cannot insert into a user table .
The OLE DB provider "SQLNCLI" for linked server "sms1" does not contain the table .. or you dont have permission .
the funny thing is when i connect directly to the server using the same usr and pass through SSMS i can do insert with no problems.
the user config is like this :
Deny select on TABLE to USER
Grant INSERT on Table to USER
DENY View Definition on Table to USER.
use master
deny View any database to USER
deny View Server STATE to USER
--- as said : its funny because when i connect direclty via SSMS whith the user , i can do insert but not through a linked server connection .. allthough sp_testlinkedserver says its OK and i can see the sys.sysusers , sys.databases frome the linked one .. I CANNOT INSERT DATA TO THAT USR TABLE ...
any IDEAS ?