Create-ReadOnly-User.md

Amazon Redshift - Creating Read Only Users

1. First, create a group that will be used for read only access: SQL

create group ro_group;

2. Revoke default create rights in the public schema:

revoke create on schema public from group ro_group;

3. Grant usage access in the public schema:

grant usage on schema public to group ro_group;

4. Grant access to current tables in the public schema:

grant select on all tables in schema public to group ro_group;

5. Grant access to future tables in the public schema:

alter default privileges in schema public grant select on tables to group ro_group;

6. Create a user:

create user ro_user with password '<password>';

7. Associate the new user and group:

alter group ro_group add user ro_user;

8. To create additional read only users, repeat steps 6 and 7.

Reference

GRANT

Other SQL