Structured Query Language For Data Management Week 2

     

    Within the Discussion Board area, 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.

     

    • 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 ?

                                                                                                                                      Order Now