The model for Streamlit in Snowflake closely maps to the owner’s rights model in stored procedures.

Streamlit apps run with the privileges of the owner, not the privileges of the caller.

Streamlit apps running in Streamlit in Snowflake run with owner’s rights and follow the same security model as other Snowflake objects that run with owner’s rights. source

Unlike caller’s rights, owner’s rights stored procedures can call only a subset of SQL statements.

The following SQL statements can be called from inside an owner’s rights stored procedure:

• SELECT.

• DML.

• DDL. (Some restrictions on the ALTER USER statement.)

• GRANT/REVOKE.

• Variable assignment.

• DESCRIBE and SHOW.

Other SQL statements cannot be called from inside an owner’s rights stored procedure. source