Microsoft
70-432 · Question #71
You are the administrator of a SQL Server 2008 instance with a database named Service with a database user named ServiceGreatUser. A SQL Server login named ServiceGreatLogin maps to ServiceGreatUser…
The correct answer is D. You should assign the appropriate database-level permissions to ServiceGreatUser. See the full explanation below for the reasoning.
Question
You are the administrator of a SQL Server 2008 instance with a database named Service with a database user named ServiceGreatUser. A SQL Server login named ServiceGreatLogin maps to ServiceGreatUser in the Service database. According to the requirement of the company CIO, the database user can only perform the two tasks below:
- the database user executes all stored procedures that currently exist
in the Sales database
- executes all stored procedures that will be created in the Sales
database. What should you do to ensure this?
Options
- AServiceGreatUser should be added to the appropriate fixed database roles.
- BYou should assign the appropriate object-level permissions to ServiceGreatUser
- CYou should assign the appropriate server-level permissions to ServiceGreatLogin
- DYou should assign the appropriate database-level permissions to ServiceGreatUser
How the community answered
(26 responses)- A4% (1)
- B4% (1)
- C12% (3)
- D81% (21)
Community Discussion
No community discussion yet for this question.