Question 490
A Data API builder endpoint exposes a stored procedure capable of deleting database records to anonymous users. The team proposes this approach: Disable anonymous invocation and grant execute only to authorized service roles. Which technical principle supports this approach?
Explanation
Correct Answer
Exposed stored-procedure endpoints require restrictive role-to-operation mapping and backend grants. A privileged procedure can still be abused by a compromised authorized role.
Incorrect Answers
That explanation assumes the wrong technical cause: DAB operation mapping and SQL EXECUTE rights need explicit authorization tests against anonymous identities.
The proposed mechanism is not sufficient because Server-side role validation and narrow backend grants—not UI visibility—protect destructive endpoints.
This inference does not follow from the SQL or service behavior: Negative role tests and trusted identity mapping are required to validate the privilege boundary. The stated assumption would still allow the documented defect to occur, so it cannot explain why the proposed fix works.