finished SQL and helper PermProp methods