Give a user just ONE table access by Mike Hinds

http://www.sqlservercentral.com/Forums/Topic982196-359-1.aspx









What we finally did was:

EXEC sp_msForEachTable 'DENY SELECT ON ? TO [TheUser]'
GO

GRANT SELECT ON [dbo].[AllowedTable] TO [TheUser]
GO

For anyone considering this, sp_msForEachTable is "non-supported". 
Regards, Mike