Câu 38: SnowPro Advanced Data Engineer

A Data Engineer has written a stored procedure that will run with caller's rights. The Engineer has granted ROLEA the right to use this stored procedure. What is a characteristic of the stored procedure being called using ROLEA?

1. A. The stored procedure must run with caller's rights; it cannot be converted later to run with owner's rights.
2. B. If the stored procedure accesses an object that ROLEA does not have access to, the stored procedure will fail. — đáp án hiện tại
3. C. The stored procedure will run in the context (database and schema) where the owner created the stored procedure.
4. D. ROLEA will not be able to see the source code for the stored procedure, even though the role has usage privileges on the stored procedure.