Skip to content

Instantly share code, notes, and snippets.

@vkhazin

vkhazin/redshift-grant.sql

Created December 7, 2023 18:17
Show Gist options
  • Save vkhazin/277e4091022c67c6db030278debd11dc to your computer and use it in GitHub Desktop.
Save vkhazin/277e4091022c67c6db030278debd11dc to your computer and use it in GitHub Desktop.
Download ZIP
How to grant read-only access to all tables in a AWS Redshift schema
Raw
redshift-grant.sql
grant select on all tables in schema {schema_name} to {db_user};
grant usage on schema {schema_name} to {db_user};
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment