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.

Answer: D

Latest 70-462 Dumps Valid Version with 301 Q&As

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments