Examice

Exam SnowPro Core All QuestionsBrowse all questions from this exam

Go to Exam

Question 483

When should a stored procedure be created with caller's rights?

When the caller needs to be prevented from viewing the source code of the stored procedure

When the caller needs to run a statement that could not execute outside of the stored procedure

When the stored procedure needs to run with the privileges of the role that called the stored procedure

When the stored procedure needs to operate on objects that the caller does not have privileges on

Correct Answer: C

A stored procedure should be created with caller's rights when the stored procedure needs to run with the privileges of the role that called the stored procedure. This allows the procedure to execute with the permissions of the user invoking it, ensuring that the actions performed by the procedure adhere to the caller's access level and restrictions.

Discussion

fahfouhi94Option: C

c is correct ==> https://docs.snowflake.com/en/sql-reference/stored-procedures-rights

_yyuktaOption: C

C. When the stored procedure needs to run with the privileges of the role that called the stored procedure

MultiCloudIronManOption: C

Correct