Snowpro Core · Free Practice Question Medium
Question 54
A stored procedure has been set up as a stored procedure with owner's rights. A system administrator runs the stored procedure. Which of the following statement correctly describes how the stored procedure will execute?
- A The stored procedure executes using the privileges of the users executing the stored procedure.
- B The stored procedure executes with ACCOUNTADMIN role permissions.
- C The stored procedure executes with SYSADMIN role permissions.
- D The stored procedure executes using the privileges of the role owning the stored procedure.
Reveal correct answer
Correct answer: D
Explanation
A stored procedure configured to run with the owner's rights executes under the privileges of the role that created and owns the stored procedure. https://docs.snowflake.com/en/sql-reference/stored-procedures-rightsDiscussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
You must be logged in to post a comment.
