Exam4Training

Which Transact-SQL statement should you use?

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_addrolemember’db_procexecutor’, ‘BillingUsers’
B . CREATE ROLE proc_caller
GRANT EXECUTE ON ALL PROCEDURES TO proc_caller
ALTER MEMBER BillingUsers ADD TO ROLE proc_caller
C . GRANT EXECUTE ON Schema::dbo TO BillingUsers
D . GRANT EXECUTE ON Contoso::dbo TOBillingUsers

Answer: D

Latest 70-764 Dumps Valid Version with 451 Q&As

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund

Exit mobile version