Question

You are the database administrator for a company. You have to enable a user to change the definition of a stored procedure. Which permission should you use?

a. Alter
b. View Definition
c. Modify
d. Execute

Answer 1

To change the definition of a stored procedure in a database, the ALTER permission must be granted to a user. This allows the user to modify the structure of the stored procedure, unlike other permissions such as View Definition or Execute, which do not permit modification. Therefore, the correct answer is a. Alter.

Step-by-step explanation:

To enable a user to change the definition of a stored procedure in a database, the appropriate permission to grant is ALTER. This permission allows a user to modify the structure of database objects, which includes stored procedures. The other options, such as View Definition, Modify, and Execute provide different levels of access: View Definition allows a user to see the object definitions, Modify is not a specific SQL permission, and Execute allows a user to run the stored procedure without altering it. Therefore, the correct answer is a. Alter.