Want to Move Your Redshift Groups, Users and Assign Them As You Did in Another DB

# spool this stuff to a file from your source db, then run the spooled SQL on your destination db # recreate your groups – the ones you want select ‘create group ‘||groname||’;’ from pg_group where groname like ‘sale%’ or groname like ‘mfg%’; # generate the create user statements select ‘create user ‘||trim(usename)||’ password ‘||”’Temp123#”;’ …

Want to Move Your Redshift Groups, Users and Assign Them As You Did in Another DB Read More »