just need the advanced challenge portion.

L Llns to perform the ftollowing actions, using the Justlee Books user account. The account name should be a combination otf your first initial es to the new account that allow connecting to the database, creating new rows in the ORDERS and ORDERITEMS tables and deleting rows , and execute sa statements the fo 1- Create new 1. and your in to Oracle 12c with the newly created account. a new user account. The ables, and altering an existy Assign and altering an existing table tables. anidount with the required privileges, create a role named CUSTOMERREP that 3 Assign privileges 253 from these tables nt created in Assignment 1 the CUSTOMERREP role. o the 5 AsSg in to racle 12c with the new account created in Assignment 1. Determine the 1 6 Logoes currently available to the account. the privilege to delete rows in the ORDERS and ORDERITEMS tables from the 7 Revoke ed after the CUSTOMERREP role the CUSTOMERREP role from the account created in Assignment 1. CUSTOMERREP role from the Oracle 12c database 9 Delete the g Delete the user account created in Assignment 1 role? Advanced Challenge lce 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 2c? s marketing activities (for example, promotions based on customers previous ourchases 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 prtvileges, a role should be created for each employee group. a user? 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. " User Creation and Management L Llns to perform the ftollowing actions, using the Justlee Books user account. The account name should be a combination otf your first initial es to the new account that allow connecting to the database, creating new rows in the ORDERS and ORDERITEMS tables and deleting rows , and execute sa statements the fo 1- Create new 1. and your in to Oracle 12c with the newly created account. a new user account. The ables, and altering an existy Assign and altering an existing table tables. anidount with the required privileges, create a role named CUSTOMERREP that 3 Assign privileges 253 from these tables nt created in Assignment 1 the CUSTOMERREP role. o the 5 AsSg in to racle 12c with the new account created in Assignment 1. Determine the 1 6 Logoes currently available to the account. the privilege to delete rows in the ORDERS and ORDERITEMS tables from the 7 Revoke ed after the CUSTOMERREP role the CUSTOMERREP role from the account created in Assignment 1. CUSTOMERREP role from the Oracle 12c database 9 Delete the g Delete the user account created in Assignment 1 role? Advanced Challenge lce 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 2c? s marketing activities (for example, promotions based on customers previous ourchases 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 prtvileges, a role should be created for each employee group. a user? 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. " User Creation and Management