Redshift create plain user, superuser, createdb user etc…

select * from pg_user_info where usename like 'mcost%';
create user mcost with createuser password '1234Mike';
create user mcost1 with password '1234Mike';
create user mcostr2 with createuser password 'MCostr123';
create user mcostr3 with createdb password 'MCostr123';
create user mcostr4 with createdb createuser password 'MCostr123';