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?
A. CREATE ROLE proc_caller
GRANT EXECUTE ON Schema: : dbo TO proc_caller ALTER ROLE proc_caller ADD MEMBER BillingUsers
B. GRANT EXECUTE ON INFORMATION_SCHEMA.ROUTINES TO BillingUsers
C. EXEC sp_addrolemember ‘executor’, ‘BillingUsers’
D. CREATE ROLE proc_caller
GRANT EXECUTE ON ALL PROCEDURES TO proc_caller
ALTER MEMBER BillingUsers ADD TO ROLE proc_caller
A
https://www.google.bg/url?sa=t&rct=j&q=&esrc=s&source=web&cd=4&ved=0ahUKEwiMqOXXs9XLAhWGCJoKHTd0AtEQFggvMAM&url=http%3A%2F%2Fstackoverflow.com%2Fquestions%2F9321334%2Fgrant-execute-to-all-stored-procedures&usg=AFQjCNElvUA5_thDZdOfOSNsU-yleQAszQ&sig2=GNlSHI3rxOtsGFyHhYiZ5A