Skip to main content

Execute As

Choose how to execute commands in Snowflake: as the CALLER initiating the operation or as the OWNER of the object being accessed.

Options: CALLER, OWNER

OptionBehavior
OWNER (default)Generated stored procedures run with the rights of the procedure owner
CALLERGenerated stored procedures run with the rights of the calling session

The value is emitted as the EXECUTE AS clause of the generated Snowflake stored procedures. A blank value is treated as OWNER.

When to Change This Setting​

Keep the default OWNER so the procedures run with consistent owner rights regardless of who invokes them. Use CALLER when the procedures should operate under the invoking session's role and privileges.

Notes​

  • This setting is part of the Snowflake settings category.
  • The default value for this setting is OWNER.