voiceofthedba.com
Rights for one table
I ran across a thread that was asking how to grant rights to a person for one table only, and not other tables. My response is simple: CREATE ROLE MySingleTableRoleGOGRANT SELECT ON dbo.MyCustomers…