Skip to content

Instantly share code, notes, and snippets.

@ericjsilva

ericjsilva/create_redshift_readonly_user.sql

Last active May 4, 2017 21:26
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ericjsilva/319847cfef50827951d96580acebc446 to your computer and use it in GitHub Desktop.
Save ericjsilva/319847cfef50827951d96580acebc446 to your computer and use it in GitHub Desktop.
Download ZIP
AWS Redshift: Create read-only user
Raw
create_redshift_readonly_user.sql
create user [username] password 'password';
grant usage on schema [schema] to [username];
alter user [username] set search_path to [schema];
grant select on all tables in schema [schema] to [username];
commit;
select * from pg_user;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment