You administer a Microsoft SQL Server database named Contoso that contains a single user-defined database role named Bil
Posted: Mon Oct 17, 2022 4:48 pm
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?
A. GRANT EXECUTE ON Schema::dbo TO BillingUsers
B. EXEC sp_addrolemember 'db_procexecutor', 'BillingUsers'
C. GRANT EXECUTE ON INFORMATION_SCHEMA.ROUTINES TO BillingUsers
D. GRANT EXECUTE ON Schema::Contoso TO 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?
A. GRANT EXECUTE ON Schema::dbo TO BillingUsers
B. EXEC sp_addrolemember 'db_procexecutor', 'BillingUsers'
C. GRANT EXECUTE ON INFORMATION_SCHEMA.ROUTINES TO BillingUsers
D. GRANT EXECUTE ON Schema::Contoso TO BillingUsers