Least privilege for stored procedures

Least privilege for stored procedures

Hard SQL DCL 20 views
Explanation Complexity

Problem Statement

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

Example

Procedures exist
User can execute only

Constraints

None

Input / Output Format

Input Format
SQL statements
Output Format
Privileges applied
Constraints
None

Examples

Input:
Procedures exist
Output:
User can execute only

Example Solution (Public)

SQL 
GRANT EXECUTE ON PROCEDURE sp_place_order TO app_user; GRANT EXECUTE ON PROCEDURE sp_pay_order TO app_user;

Official Solution Code

GRANT EXECUTE ON PROCEDURE sp_place_order TO app_user; GRANT EXECUTE ON PROCEDURE sp_pay_order TO app_user;
Please login to submit solutions.
Editor
Output

                                        

                                    

                                    

                                        

                                                                                    
Please login to submit solutions.