Least privilege for stored procedures
SQL
Hard
3 views
Problem Description
User app_user should not query base tables directly but can call procedures sp_place_order and sp_pay_order. Write grants only for procedures.
Input Format
SQL statements
Output Format
Privileges applied
Sample Test Case
Output:
User can execute only
Official Solution
GRANT EXECUTE ON PROCEDURE sp_place_order TO app_user; GRANT EXECUTE ON PROCEDURE sp_pay_order TO app_user;
Solutions (0)
No solutions submitted yet. Be the first!
No comments yet. Start the discussion!