Stored procedures don't respect roles. You have to grant the priviledges directly.