Use the JustLee Books database to perform the following activity: There are three major classifications for employees
Question:
Use the JustLee Books database to perform the following activity:
There are three major classifications for employees who don’t work for the Information Systems Department of JustLee Books: account managers, who are responsible for the company’s marketing activities (for example, promotions based on customers’ previous purchases or for specific books); data entry clerks, who enter inventory updates (for example, add new books and publishers, change prices, and so on); and customer service representatives, who are responsible for adding new customers and entering orders in the database. Each employee group has different tasks to perform and, therefore, needs different privileges for various tables in the database. To simplify administration of system and object privileges, a role should be created for each employee group. Create a document for your supervisor that contains the following information:
• List the tables that each group of employees needs to access from these tables:
BOOKS, CUSTOMERS, ORDERS, ORDERITEMS, AUTHOR, BOOKAUTHOR, PUBLISHER, and PROMOTION.
• Name the privileges each group of employees needs.
• For each group of employees, name a role containing the necessary privileges for that group.
• For all groups of employees, list the exact commands for creating and assigning specific privileges to their roles.
• Explain your rationale for the privileges granted to each role.
Step by Step Answer: