What should you do?

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?
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_Add!nventory to all users. Add all users to the db_datareader role.

View Answer

Answer: D