text: /* add new role to the water_admin application for managing billing accounts */
  insert into idm.roles
    select
      public.gen_random_uuid(),
      'water_admin',
      'manage_billing_accounts',
      'View invoice accounts and change invoice account address',
      now(),
      now();
  
  
  /**
   * Add the new role to groups
   */
  
  insert into idm.group_roles
    select
      public.gen_random_uuid() as group_role_id,
      g.group_id as group_id,
      (select role_id from idm.roles where "role" = 'manage_billing_accounts') as role_id,
      now() as date_created,
      now() as date_updated
    from idm.groups g
    where g.application = 'water_admin'
    and g.group in ('super', 'billing_and_data', 'nps');