You administer a Microsoft SQL Server 2016 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 permissions for all stored

procedures in Contoso to BillingUsers.

Which Transact-SQL statement should you use?

A. EXEC sp_addrolememberdb_procexecutor, BillingUsers

B. CREATE ROLE proc_caller

GRANT EXECUTE ON ALL PROCEDURES TO proc_caller

ALTER MEMBER BillingUsers ADD TO RO

LE proc_caller

C. GRANT EXECUTE ON Schema::dbo TO BillingUsers

D. GRANT EXECUTE ON Contoso::dbo TOBillingUsers