Question: Use the JustLee Books database to perform the following activity: There are three major classifications for employees who dont work for the Information Systems Department

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 Solution

3.50 Rating (187 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

The following chart is one poss... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (2 attachments)

PDF file Icon

1803_60b8c12126413_716334.pdf

180 KBs PDF File

Word file Icon

1803_60b8c12126413_716334.docx

120 KBs Word File

Students Have Also Explored These Related Oracle 12c SQL Questions!