I have a SQL Server 2008 R2 database that I need to restrict so that only one individual, mjones, can add records to a specific table.
Only mjones should be able to add records to TableOne.
Everyone else can add records to other tables in the database, but not that one.
Everyone can view records in every table, including TableOne.
Everyone can UPDATE records in every table, including TableOne. They just can't add new records to TableOne. Except for mjones. She, and only she, can add records to TableOne.