You administer a Microsoft SQL Server 2012 database named ContosoDb. The database contains
a table named Suppliers and a column named IsActive in the Purchases schema. You create a
new user named ContosoUser in ContosoDb. ContosoUser has no permissions to the Suppliers
table. You need to ensure that ContosoUser can delete rows that are not active from Suppliers.
You also need to grant ContosoUser only the minimum required permissions. Which Transact-SQL
statement should you use?

A.
GRANT DELETE ON
Purchases.Suppliers TO ContosoUser

B.
CREATE PROCEDURE
Purchases.PurgeInactiveSu ppliers
WITH EXECUTE AS USER = ‘dbo’
AS
DELETE FROM Purchases.Suppliers
WHERE IsActive = 0
GO GRANT EXECUTE ON
Purchases.PurgelnactiveSu ppliers TO ContosoUser

C.
GRANT SELECT ON
Purchases.Suppliers TO ContosoUser

D.
CREATE PROCEDURE
Purchases.PurgeInactiveSu ppliers
AS
DELETE FROM Purchases.Suppliers
WHERE IsActive = 0
GO
GRANT EXECUTE ON
Purchases.PurgeInactiveSu ppliers TO ContosoUser

Explanation:
Incorrect syntax near the keyword ‘USER’ in option B.
http://msdn.microsoft.com/en-us/library/ms188354.aspx
http://msdn.microsoft.com/en-us/library/ms187926.aspx