Question 70
A schema migration adds a stored procedure but the production app service role cannot execute it. Initial testing shows: App calls succeed with intended permissions while forbidden actions fail. Which limitation should the team still consider?
Explanation
Correct Answer
Test credentials must not be copied from production secrets. CI/CD integration testing should use representative application identities and permissions.
Incorrect Answers
Application permissions differ from deployment-operator permissions; tests must use a representative low-privilege identity.
Module execution rights and ownership/role context require explicit verification for the deployed procedure.
A sound test validates both allowed and denied operations using scoped test credentials, never unrestricted access.