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?
A.
The stored procedure must run with caller's rights; it cannot be converted later to run with owner's rights.
B.
If the stored procedure accesses an object that ROLEA does not have access to, the stored procedure will fail.
C.
The stored procedure will run in the context (database and schema) where the owner created the stored procedure.
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.
A caller’s rights stored procedure runs with the database privileges of the role that called the stored procedure. Any statement that the caller could not execute outside the stored procedure cannot be executed inside the stored procedure, either. For example, if the role named “Nurse” does not have privileges to delete rows from the medical_records table, then if a user with the role “Nurse” calls a caller’s rights stored procedure that tries to delete rows from that table, the stored procedure will fail.
https://docs.snowflake.com/en/developer-guide/stored-procedure/stored-procedures-rights#caller-s-rights-stored-procedures
upvoted 1 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
stopthisnow
1Â month, 1Â week ago