Andrea is a member of the Sales and Marketing roles in your database. She needs Select, Insert, and Update permissions on your table. With security configured as shown in Table 14-2, how can you grant her the necessary permissions?
(Removing Andrea from the Sales role will give her the permissions she needs. She will inherit the Select permission from the public role and the Insert and Update permissions from the Marketing role. None of the other options would work because as long as Andrea is a member of Sales, she would be denied the Select permission because Sales has been denied the permission.)