There should be some mechanic that makes roles more likely to get spellbooks that they can get skill in, possibly biasing random generation for spellbooks towards such spells.