A Data Engineer has written a stored procedure that will run with caller's rights.

A stored procedure that runs with caller’s rights executes with the privileges of the role that calls it. Therefore, if the stored procedure accesses an object that ROLEA does not have access to, such as a table or a view, the stored procedure will fail with an insufficient privileges error. The other options are not correct because:

A stored procedure can be converted from caller’s rights to owner’s rights by using the ALTER PROCEDURE command with the EXECUTE AS OWNER option.

A stored procedure that runs with caller’s rights executes in the context (database and schema) of the caller, not the owner.

ROLEA will be able to see the source code for the stored procedure by using the GET_DDL function or the DESCRIBE command, as long as it has usage privileges on the stored procedure.