Creating users in PostgreSQL (and by extension Redshift) that have exactly the permissions you want is, surprisingly, a difficult task.