Roles and permissions

Jon - the mdl_role_assignments table holds the information about teacher, students, and other roles for a class. If you are interested, send me an email request for the sql I use to populate our system and I will show you what I do at the beginning of the year. I have comments explaining the steps so it should give you some insights into what tables contain the various pieces. Peace -Anthony