PrepAway - Latest Free Exam Questions & Answers

You need to ensure that the database user can perform only the following tasks: -Execute all stored procedur

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?

PrepAway - Latest Free Exam Questions & Answers

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.


Leave a Reply