How to Grant SELECT on a Table in Snowflake
Last updated July 25, 2026 · By the SaturnSQL team
GRANT SELECT ON TABLE ... TO ROLE gives read access, but the role also needs USAGE on the database and schema to reach the table. Future grants on the schema cover tables created later.
The full set of grants for read access
GRANT USAGE ON DATABASE analytics TO ROLE analyst;
GRANT USAGE ON SCHEMA analytics.public TO ROLE analyst;
GRANT SELECT ON TABLE analytics.public.orders TO ROLE analyst;All current and future tables in a schema
GRANT SELECT ON ALL TABLES IN SCHEMA analytics.public TO ROLE analyst;
GRANT SELECT ON FUTURE TABLES IN SCHEMA analytics.public TO ROLE analyst;Verify
SHOW GRANTS ON TABLE analytics.public.orders;
SHOW GRANTS TO ROLE analyst;Run this in SaturnSQL
SaturnSQL is a browser-based SQL editor for teams: shared query library, schema-aware autocomplete, and scheduled exports to Google Sheets and Slack.
Try it free