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

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?

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.



Leave a Reply 0

Your email address will not be published. Required fields are marked *