
Answer-first summary for fast verification
Answer: OWNERSHIP, USAGE
Based on Snowflake documentation and the community discussion, stored procedures support two specific privileges: USAGE and OWNERSHIP. The USAGE privilege enables roles to call/execute the stored procedure, while OWNERSHIP grants full control over the stored procedure including the ability to alter or drop it. The community discussion clearly indicates these are the only two privileges that apply to stored procedures, with 100% consensus on answers D and E. Other options like MODIFY, MONITOR, and OPERATE are not valid privileges for stored procedures in Snowflake.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.