The script will Extract Roles attribution Definition in Vertica. SELECT 'GRANT ROLE ' || all_roles || ' TO ' || user_name || ';' ATRIBUTES FROM v_catalog.users ORDER BY 1;
SELECT 'GRANT ROLE ' || all_roles || ' TO ' || user_name || ';' ATRIBUTES FROM v_catalog.users ORDER BY 1;