I need to give read only access to view which resides on my server to my client. So the obvious way to do is by using Linked Server on the client machine. I successfully created it by using
EXEC sp_addlinkedserver @server = 'MyServer_Name'
Now client server able to access records from view using
SELECT * FROM [MyServer_Name].[Database_Name].[dbo].[View_Name]
After creating Linked Server, my client able to view all databases & there resp tables & views under Catalogs menu of created Linked Server. I want to hide all this information under Catalog menu.
How to achieve this?
Is there any other way besides Linked Server to grant read only access to view.
Thanks in advance.