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_Add inventory to all users. Grant VIEW DEFINITION to all users.
B. Grant EXECUTE permission on p_Add Inventory to all users. Add all users to the db_data writer role.
C. Add all users to the db_owner role.
D. Grant EXECUTE permission on p_Add inventory to all users. Add all users to the db_data reader role.
Answer: D
Microsoft 70-762 Dumps - 70-762 Question Answer - Dumps4download.in
No comments:
Post a Comment