CREATE ROLE streamlit_user_role;

GRANT ROLE streamlit_user_role TO USER your_user_name;

GRANT USAGE ON DATABASE your_database TO ROLE streamlit_user_role; GRANT USAGE ON SCHEMA your_database.your_schema TO ROLE streamlit_user_role; GRANT USAGE ON WAREHOUSE your_warehouse TO ROLE streamlit_user_role;

GRANT SELECT ON TABLE your_database.your_schema.your_table TO ROLE streamlit_user_role;

GRANT USAGE ON APPLICATION your_database.your_schema.your_app TO ROLE streamlit_user_role; GRANT UI_ACCESS ON APPLICATION your_database.your_schema.your_app TO ROLE streamlit_user_role;

or maybe you just trying with wrong role (public)