How do we create a link between authorized users and database collection to that user?

I am creating a training courseware system and we want to be able to have the teachers for a course be an attribute on the course as well as the students for a course be an attribute. We know relational SQL and beyond, but we don't know how to connect the Auth user to the collection.

create log in and sign up and you have to use a separate role for teachers and treat students as normal users

Not all students will be registered for all courses. We need to limit who can edit a course, thus the teacher of that course. We also need to limit who can take the course on a course by course basis, thus the students.

Are we supposed to create a unique team for each course? Is that the platform approach?

Teams is a way for users to share access to multiple users. so, yes, this might be a good use case for teams