Redshift

CREATE USER artie_transfer WITH PASSWORD 'password';
GRANT SELECT, INSERT, UPDATE, DELETE, DROP, ALTER ON ALL TABLES IN SCHEMA schema_name TO artie_transfer;
GRANT CREATE, USAGE ON SCHEMA schema_name TO artie_transfer;