PrepAway - Latest Free Exam Questions & Answers

You need to grant only the necessary permissions

You administer a Windows Azure SQL Database database named Inventory that contains a stored procedure
named p_AddInventory.
Users need to be able to SELECT from all tables in the database and execute the stored procedure.
You need to grant only the necessary permissions.
What should you do?

PrepAway - Latest Free Exam Questions & Answers

A.
Grant EXECUTE permission on p_AddInventory to all users. Grant VIEW DEFINITION to all users.

B.
Grant EXECUTE permission on p_AddInventory to all users. Add all users to the db_datawriter role.

C.
Add all users to the db_owner role.

D.
Grant EXECUTE permission on p_AddInventory to all users. Add all users to the db_datareader role.

Explanation:
Members of the db_datareader fixed database role can run a SELECT statement against any table or view in
the database.
https://technet.microsoft.com/en-us/library/ms188629(v=sql.90).aspx


Leave a Reply