Câu 62: 70-462: MCSA Administering Microsoft SQL Server 20122014 Databases

You administer a Microsoft SQL Server database named Contoso that contains a single user-defined database role named BillingUsers. 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. GRANT EXECUTE ON Schema::dbo TO BillingUsers — đáp án hiện tại
2. B. EXEC sp_addrolemember 'db_procexecutor', 'BillingUsers'
3. C. GRANT EXECUTE ON INFORMATION_SCHEMA.ROUTINES TO BillingUsers
4. D. GRANT EXECUTE ON Schema::Contoso TO BillingUsers