SnowPro Advanced Data Engineer

By Snowflake · Question Mode

QuestionQ90

Implement Data Protection and Recovery

A Data Engineer has created a stored procedure that runs with the caller’s rights. The Engineer has granted ROLEA permission to use this stored procedure.

What is a characteristic of calling the stored procedure by using ROLEA?

Explanation

A caller’s-rights stored procedure runs with the database privileges of the role that calls it. Granting ROLEA USAGE on the procedure permits execution but does not provide privileges on objects accessed inside it; access to an object that ROLEA cannot access causes the procedure to fail.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!