sql and role changes partials