Question: Use SQL Developer or VS Code to write the commands to perform the task below. Then copy and paste your SQL statements into the submission
Use SQL Developer or VS Code to write the commands to perform the task below. Then copy and paste your SQL statements into
the submission box. Note that you may not have enough privilege to actually create a role or assign privileges. This assignment
should be completed by April
JustLee Books wants to create a role for customer service representatives. These employees need to be able to enter new orders
and customers into the database as well as cancelling or modifying existing orders. They need to be able to see the details about
each order, including the book, author, and publisher information. Please write the commands necessary to create the role and give
the role the necessary privileges for the appropriate tables. Think about what tables the employees will need to be able to look at
SELECT as well as those they will need to be able to UPDATE, DELETE or INSERT rows. Don't forget to include any bridging tables
that might be necessary.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
