Microsoft
70-432 · Question #148
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…
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.
How the community answered
(19 responses)- A11% (2)
- B5% (1)
- C5% (1)
- D79% (15)
Community Discussion
No community discussion yet for this question.