How to Grant SELECT on a Table in Redshift
Last updated July 25, 2026 · By the SaturnSQL team
Use GRANT SELECT ON table TO user or group, plus GRANT USAGE ON SCHEMA so the user can reach the schema at all. ALTER DEFAULT PRIVILEGES makes future tables inherit the grant automatically.
GRANT USAGE ON SCHEMA analytics TO GROUP reporting;
GRANT SELECT ON ALL TABLES IN SCHEMA analytics TO GROUP reporting;Cover future tables too
ALTER DEFAULT PRIVILEGES IN SCHEMA analytics
GRANT SELECT ON TABLES TO GROUP reporting;GRANT ... ON ALL TABLES only affects tables that exist right now; without the ALTER DEFAULT PRIVILEGES line, every new table needs a fresh grant. Missing USAGE on the schema is the usual cause of permission denied errors despite a SELECT grant.
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