You administer a SQL Server 2008 instance that contains a database named Sales.
A SQL Server login named SalesAppLogin maps to a database user named SalesAppUser
in the Sales database.
You need to ensure that the database user can perform only the following tasks:
-Execute all stored procedures that currently exist in the Sales database. -Execute all stored
procedures that will be created in the Sales database.
What should you do?
A.
Add SalesAppUser to the appropriate fixed database roles.
B.
Grant the appropriate object-level permissions to SalesAppUser.
C.
Grant the appropriate server-level permissions to SalesAppLogin.
D.
Grant the appropriate database-level permissions to SalesAppUser.