write 400–600 words that respond to the following questions with your thoughts, ideas, and comments. This will be the foundation for future discussions by your classmates. Be substantive and clear, and use examples to reinforce your ideas:
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.
- Provide a brief explanation of the SQL server security model. What objects exist?
- Explain how those objects available in the security model can be used to implement the class scheduler.