400-600 word assignment for designing the base set of tables for the project, the topic of security was brought up

After designing the base set of tables for the project, the topic of security was brought up. Designing in security at an early stage of the project will make it easier to properly close potential loopholes.

As an example, one type of user is being considered. A class scheduler will be a user who can assign students to classes. He or she can view student and class information but cannot edit that data—he or she can only edit data in the Students_Classes table.

Discuss how the class scheduler can be limited to access a specific database or table. Also specify which login method you recommend to be used and the reasons for your recommendation?