You administer a Microsoft 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. Create a new database role. Grant EXECUTE permission on p_AddInventory to the new role. Grant VIEW DEFINITION to the role. Add all users to the role.
B. Add all users to the db_datawriter role. Add all users to the db_datareader role.
C. Grant EXECUTE permission on p_AddInventory to all users. Grant VIEW DEFINITION to all users.
D. Create a new database role. Grant EXECUTE permission on p_AddInventory to the new role. Add all users to the role. Add all users to the db_datareader role.

  Discussion forum

Question
0

Leave an answer