Microsoft
70-432 · Question #148
70-432 Question #148: Real Exam Question with Answer & Explanation
The correct answer is D. Grant the appropriate database-level permissions to SalesAppUser.. See the full explanation below for the reasoning.
Question
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?
Options
- AAdd SalesAppUser to the appropriate fixed database roles.
- BGrant the appropriate object-level permissions to SalesAppUser.
- CGrant the appropriate server-level permissions to SalesAppLogin.
- DGrant the appropriate database-level permissions to SalesAppUser.
Community Discussion
No community discussion yet for this question.