Grant execute on a procedure
SQL
Easy
2 views
Problem Description
Procedure sp_monthly_sales exists. Give user accountant permission to execute it.
Input Format
SQL statements
Output Format
Privilege applied
Sample Test Case
Input:
sp_monthly_sales exists
Official Solution
GRANT EXECUTE ON PROCEDURE sp_monthly_sales TO accountant;
Solutions (0)
No solutions submitted yet. Be the first!
No comments yet. Start the discussion!