Redshift – Script to generate statements to recreate users and groups

--Script to generate statements to re-create users in redshift
select 'create user '+ usename +' password ''Hidden1!'' ;' from pg_user
order by usename asc;

--Script to generate statements to re-create groups 
select 'create group '+ groname +';' from pg_group
order by groname asc;

--Script to generate statements to add users to various groups
SELECT 'alter group '+ groname + ' add user ' + usename + ';'
FROM "admin".v_get_users_in_group
order by groname , usename;