SQL2005 security, grant user explicit read access to certain table

microsoft.public.sqlserver.programming

24 Aug 2006 3:45 PM

walanta <>

Hi,

We have a database on SQL2005 with 50 tables.
We want to grant someone read table rights to only some tables.

Right now we created a SQL account and he can connect and read all
tables in this database.

I gave this user as db_datareader in Database role membership in
security.

How can I easily stop that? Is there a place I can check to deny him
any access and just grant him a few tables? Thanks!!