Reminder: Initial Discussion Board posts due by Wednesday, responses due by Sunday
Students will be expected to post their first initial discussion board posting by Wednesday of each week. Discussion posts will be graded and late submissions will be assigned a late penalty in accordance with the late penalty policy found in the syllabus. NOTE: All submission posting times are based on midnight Central Time.
Students are expected to post their responses to peers by Sunday. NOTE: All submission posting times are based on midnight Central Time.
Primary Task Response: Within the Discussion Board area, write 400600 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 datahe 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.