Câu 33: 70-764: Administering a SQL Database Infrastructure

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?

1. A. EXEC sp_addrolemember'db_procexecutor', 'BillingUsers'
2. B. CREATE ROLE proc_caller GRANT EXECUTE ON ALL PROCEDURES TO proc_caller ALTER MEMBER BillingUsers ADD TO ROLE proc_caller
3. C. GRANT EXECUTE ON Schema::dbo TO BillingUsers
4. D. GRANT EXECUTE ON Contoso::dbo TOBillingUsers — đáp án hiện tại