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

Question

Subha Mishra · Accepted Answer

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

Subha Mishra · Answer

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

Subha Mishra · Answer

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

Subha Mishra · Answer

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

List of questions