Your SQL Server system stores information about suppliers in the Suppliers table. Table 14-1 shows the security setup for the table, Joe belongs to the Administration and Marketing roles in the database, and he needs to be able to perform Inserts, Updates, and Deletes on the table. Which command should you use to give these permissions?
(Marketing has been denied the Select, Update, and Insert permissions, and this overrides any other permission settings. So, even though Joe has been specifically granted these permissions, he cannot use them because he is a member of a group that has been denied the permissions. The only way to get the permissions for him is to remove him from the group that has been denied these permissions.)