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

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?

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