How to create a read-only user on Amazon Redshift. http://awsdocs.s3.amazonaws.com/redshift/latest/redshift-dg.pdf

read_only_user_on_redshift.md

• Setup Database

create database [db-name];
revoke all on schema public from public;
create schema [schema-name];
create table [schema-name].[table-name](
  ...
) 

• Create Read-only User

create user [user-name] password '[password]';
grant usage on schema [schema-name] to [user-name];
alter user [user-name] set search_path to [schema-name];
grant select on table [schema-name].[table-name] to [user-name];

I don't think it is necessar
alter user [user-name] set search_path to [schema-name];

very helpful :)

I used grant select on all tables in schema [schema-name] to [user-name]; for the last step