Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
Under what circumstances should a stored procedure be created with EXECUTE AS CALLER?
EXECUTE AS CALLER
A
When the caller needs to be prevented from viewing the source code of the stored procedure
B
When the caller needs to run a statement that could not execute outside of the stored procedure
C
When the stored procedure needs to run with the privileges of the role that called the stored procedure
D
When the stored procedure needs to operate on objects that the caller does not have privileges on