Using Microsoft SQL Server 2008, is it possible for a SQL Server account to be given privileges on a per-table basis within a database? For example, to have read access to all tables but write access to only one of the tables.
I am already familiar with the per-database security settings.