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 ContosoUs

er 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 sta

tement should you use?

A. GRANT DELETE ON Purchases.Suppliers TO ContosoUser

B. CREATE PROCEDURE Purchases.PurgeInactiveSuppliers

WITH EXECUTE AS USER = dbo

AS

DELETE FROM Purchases.Suppliers WHERE IsActive = 0

GO

GRANT EXECUTE ON Purchases.Purgelnacti

veSuppliers TO ContosoUser

C. GRANT SELECT ON Purchases.Suppliers TO ContosoUser

D. CREATE PROCEDURE Purchases.PurgeInactiveSuppliers

AS

DELETE FROM Purchases.Suppliers WHERE IsActive = 0

GO

GRANT EXECUTE ON Purchases.PurgeInactiveSuppliers TO

ContosoUser

Reference: http://msdn.microsoft.com/en-us/library/ms188354.aspx

Reference: http://msdn.microsoft.com/en-us/library/ms187926.aspx