Does MS SQL Server 2000 have the ability to limit user access to certain tables in a database?
We have a client that is connecting to our db using VPN and loading data into some tables and retrieving data from other tables. What we want to do is restrict them from seeing any other tables in our database.
Is this possible? If so, how?