def METHOD_NAME(offering):
    """
    Build list of all repositories active for this course offering (so we can know for sure which ones must change).
    Returns dictionary of repository name to (ro users, rw users)
    """
    if not settings.SVN_DB_CONNECT:
        # don't try if not configured
        return {}
    db = _db_conn()
    db.execute('SELECT `repository`, `read`, `readandwrite` FROM '+SVN_TABLE+' WHERE `repository` LIKE %s', ('%' + offering.subject.upper() + offering.number[0:3] + '-' + offering.semester.name + '-%',))
    repos = {}
    for row in db:
        repo, ro, rw = row
        if ro:
            ro = ro.split(',')
        else:
            ro = ''
        if rw:
            rw = rw.split(',')
        else:
            rw = ''
        repos[repo] = (set(ro), set(rw))
    return repos