You administer a Microsoft SQL Server 2012 database named Contoso that contains a single user-defined database role

namedBillingUsers.

All objects in Contoso are in the dbo schemA.

You need to grant EXECUTE permission for all stored procedures in Contoso to BillingUsers.

Which Transact-SQL statement should you use?

A. CREATE ROLE proc_caller

GRANT EXECUTE ON Schema:

: dbo TO proc_caller

ALTER ROLE proc_caller ADD MEMBER BillingUsers

B. GRANT EXECUTE ON INFORMATION_SCHEMA.ROUTINES TO BillingUsers

C. EXEC sp_addrolemember executor, BillingUsers

D. CREATE ROLE proc_caller

GRANT EXECUTE ON ALL PROCEDURES TO proc_ca

ller

ALTER MEMBER BillingUsers ADD TO ROLE proc_caller