Applying authenticated user permissions to course activities

I had a few courses that did not migrate cleanly from moodle 1.9 - 2.3.  I ultimately did get these courses to backup and then restore with very limited options chosen in the backup process.  One of the options I unselected or did not include was the roles.  I recall unselecting all the roles while building my backup files.

Today, my customer contacted me with a problem with some of the students not being able to view an assignment in the course.  My first thought was user error, but upon further review I found that none of the assignments had student or authenticated role permissions. 

I turned on editing mode, selected one of the assignments in the course and checked the permissions and saw that only the teacher, manager and non-editing teacher roles had permission to View or Submit assignments.  This problem is very likely due to me unselected all the roles in the backup file in the 1.9 instance that i used to restore to the 2.3 instance.

I added the roles to the Submit and View assignment permissions and checked my thinking and was all set.  I checked by while logged in as admin, changing my role to student.

There are about 25 assigments in the course, so I looked in the DB to see if i could easily automate this process, rather than adding permissions manually to each assignment in the course.  I quickly found myself in deep water with the permissions, context, assignment "concepts" in the DB.  This is like the black box in the moodle DB....I punted and instead turned on the Activities Block, where I could at least click on the Activities link and see all of them in a single form.  I then CRTL clicked each assignment, opening it in its own tab.  I ended up with 23 open tabs.  I went to each one, clicked on the permissions link in Course Admin and added the Submit and View permission.  This process took about 30 minutes.  A little tedious yes, but worth it to solve the problem for my customer.

This is my reminder to check the other courses that migrated from the *limited BU files from moodle 1,9.  I may have to so the same thing with them.  There are probably other permissions missing, but I think i will wait for my customer to alert me.

Other courses:
wartime 20th century
phychology
sociology
international relations

Moral of the story?
There are consequences of disabling roles when creating backups....