This is regarding a permission issue, I recently created a linked server with permission SA. After a few week, before moving to production I would like to make the user a read only user, in case someone trying to overwrite the data from this link server access.
Server is MS SQL2008 R2.
When I try a user (this is the user that is on the linked server). I am getting error:15007, "USER" is not a valid login or you do not have permission.
I have already given the user sysadmin, on user mapping .I have given db_datareader for all the database it is trying to access.
Per another suggestion Did below. Still getting the same error message. Any ideas?
GRANT ALTER ANY LOGIN TO USER
GRANT ALTER ANY LINKED SERVER TO MDVBO_READONLY