I have an SQL Server on a remote server to which i log in with a specific username and password. I want to allow other users access to three tables only on one specific database for them to view and download data. How can i give them access without giving them the admin username and password that will give them access to all the databases? I am using SQL 2005 at the moment but i am migrating it all to 2008 in the coming weeks but assume the solution will work for both.
thanks for any help
thanks for any help