Question 90
A team wants to block insecure GRANT statements in database scripts before deployment. The team is considering this step: Add a reviewed SQL policy gate and require exception approvals. What evidence should they review before proceeding?
Explanation
Correct Answer
Identify banned grants, approved exceptions and parser coverage. Static analysis and policy-as-code can scan SQL project changes for risky permission patterns.
Incorrect Answers
Compilation alone does not enforce permission policy; explicit static rules and runtime controls are needed for broader grants.
Branch names and unconditional exceptions do not prove least-privilege; tests must show prohibited grants are blocked with traceable review.
Privileges can be conveyed through procedures and other objects; policy coverage must include relevant GRANT syntax and negative fixtures.