What is a feature of a stored procedure in Snowflake?
What is a feature of a stored procedure in Snowflake?
Stored procedures in Snowflake can be created to run with a caller's rights or an owner's rights. This feature allows the stored procedure to either execute with the privileges of the role that calls the procedure (caller’s rights) or with the privileges of the role that owns the procedure (owner’s rights), providing flexibility in how permissions and access controls are managed.
D is correct
Correct
With a stored procedure, you can also: Dynamically create and execute SQL statements. Execute code with the privileges of the role that owns the procedure, rather than with the privileges of the role that runs the procedure. This allows the stored procedure owner to delegate the power to perform specified operations to users who otherwise could not do so. However, there are limitations on these owner’s rights stored procedures.