Skip to content

Instantly share code, notes, and snippets.

@sankalpk

sankalpk/gist:2d7d49ed073217402db8e94af1fa481a

Created May 13, 2019 18:06
Show Gist options
  • Save sankalpk/2d7d49ed073217402db8e94af1fa481a to your computer and use it in GitHub Desktop.
Save sankalpk/2d7d49ed073217402db8e94af1fa481a to your computer and use it in GitHub Desktop.
Download ZIP
Create Redshift Read Only User
Raw
gistfile1.sql
CREATE GROUP ro_group;
CREATE USER <user_name> WITH password '<password>';
ALTER GROUP ro_group ADD USER <user_name>;
GRANT USAGE ON SCHEMA "public" TO GROUP ro_group;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment