Database Fundamentals — Question 53

Which permission does a user need in order to run a stored procedure?

Answer options

• A. EXECUTE
• B. ALLOW
• C. CALL
• D. RUN

Correct answer: A

Explanation

The EXECUTE permission is specifically needed for a user to run stored procedures in a database. The other options, ALLOW, CALL, and RUN, do not correspond to the necessary permission required for executing stored procedures.