You work as a developer at ABC.com. The ABC.com network consists of a single domain named
ABC.com. ABC.com subscribes to SQL Azure.
You have created a database, named ABCDB1, which includes two tables, named ABCTableA
and ABCTableB. You have also generated a stored procedure, which reads information from
ABCTableA, then adds it to ABCTableB.
A database user complains that she is unable to implement the stored procedure, even though
she has the SELECT permission on both tables. You have to make sure that the user has the
ability to implement the stored procedure, without assigning unnecessary permissions.
Which of the following actions should you take?
A.
You should consider assigning the user the CONTROL permission on the stored procedure.
B.
You should consider assigning the user the ALTER permission on the stored procedure.
C.
You should consider assigning the user the VIEW DEFINITION permission on the stored
procedure.
D.
You should consider assigning the user the EXECUTE permission on the stored procedure.
Explanation:
B
Why would she need the ALTER permission, when the question says she’s able to SELECT from the two tables?! Her inability to use the stored procedure to select from one table and add to the other table, has to do with her not having the EXECUTE permission on the stored procedure.