Question 110
Application callers need to execute a controlled administrative action without receiving broad table modification permissions. Initial testing shows: Caller performs only authorized operation and direct table updates remain forbidden. Which limitation should the team still consider?
Explanation
Correct Answer
Dynamic SQL can change permission behavior and requires separate safeguards. Module execution context and EXECUTE permission can encapsulate approved database operations. Grant execution on a tightly reviewed procedure with minimum underlying rights.
Incorrect Answers
EXECUTE on the administrative procedure is not the same as a direct UPDATE grant. Check effective table rights separately; broad update permission would defeat the intended containment.
EXECUTE AS can change the execution identity exposed to SQL auditing and functions. Audit attribution needs a deliberate caller-correlation or signing design.
Modifying a certificate-signed procedure may require signing it again. Its effective authorization must be retested before deploying modified code.